•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
how to remove dash "-" from a string of numbers
example : 000-111-222-00000 would return as 00011122200000 (zeroes in the front should be retained)
presently, what i do is just copy the numbers and use the find and replace, but the list is a continuous list, so i keep adding new numbers and copy and pasting, then using find and replace, so i wanted to "automate" that part.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#remove dash
#find and replace
#automate
#string of numbers
#automation
#zeroes retained
#copy and replace
#Excel
#continuous list
#digit manipulation
#string manipulation
#number formatting
#data processing
#text processing
#data cleanup
#script automation