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 decimals and dash from each line to display the numbers only. Is thi
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.
4 Replies
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.
- Thank you sooooooooooooooooooooooooooo much! You saved me. 🙂
Mrsalwayswright1 , glad to help
- Try:
=—SUBSTITUTE(SUBSTITUTE(A1,
“.”,””),”-“,””)
