1 min readfrom 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.

submitted by /u/mrklmngbta
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article