Trying to surround Text with other characters in sheets
Im trying to see if there is a way to surround text within one of my cells with asterisks on both sides "*". Im trying to accomplish this in a helper cell after submission within my form goes to a sheet. Similar to the function in excel- ="*"&A1&"*" but with "A1" being the cell I'm trying to surround with asterisks -[Request Number]@row
Not sure if this is possible in some way or is there a way to have my form submission auto put in asterisks on both side of my cells value
Help Article Resources
Check out the Formula Handbook template!