Forum Discussion
Mrsalwayswright1
Jan 29, 2020Copper Contributor
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...
- Jan 29, 2020
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.
Mrsalwayswright1
Jan 29, 2020Copper Contributor
Thank you sooooooooooooooooooooooooooo much! You saved me. 🙂
SergeiBaklan
Jan 29, 2020Diamond Contributor
Mrsalwayswright1 , glad to help