How to format text in a row all at once to be uniform
I am copying and pasting manual standards into a sheet. When pasted, the number reads "-1" and I want to make it be formatted "1." I would like to do this for all rows at the same time.
Answers
-
Easy to remove the dash "-" but not sure about adding the "." so can only half help…
If you're not using the dash elsewhere in the sheet, you could do a find and replace:
Ctrl F
Under Find write -
Don't write anything in Replace With
Press Replace All -
Thank you, that worked! Now I just need to figure out how to add the ".".
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!