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.
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
