Forum Discussion
Solved
removing dashes and decimals
Good morning everyone! I have a question that may be simple for someone. I have a spreadsheet that has a row full of numbers that look like this: 9.841-074.0 I need to remove the decimal...
If that's one time job and above is not result of calculations you may do that manually - select rows with texts in question, Ctrl+H, find dot, replace on nothing, Replace All. Same with dashes.
Try:
=—SUBSTITUTE(SUBSTITUTE(A1,
“.”,””),”-“,””)
=—SUBSTITUTE(SUBSTITUTE(A1,
“.”,””),”-“,””)