Hey all. I'm trying to sort through duplicates of phone numbers but unfortunately, some entries have (+, -, or " ") in them. Is there a way I can delete all these characters from my data? :D
Hey all. I'm trying to sort through duplicates of phone numbers but unfortunately, some entries have (+, -, or " ") in them. Is there a way I can delete all these characters from my data? :D
Ctrl+H and replace each character with nothing
Thanks for that suggestion, but I've got a LOT of phone numbers. I've already written up the search code to compare exact words but I was just hoping if there was a function that could omit certain characters, or a way to make a function that goes through each line and deletes all of them.
Oh god, that worked. LOL! I'm a moron. Thanks, you're awesome. <3
For replacing you can select:
- one cell
- whole sheet
- one ore more rows
- one or more columns
So when you want to replace in part of the workbook you can select just that part.
In your case probably whole sheet (Ctrl+A) should work
It works except for the spacebar. Darn spacebar.
Spacebar should also work but it will remove all spacebars in the words.
For example if you have names there it will remove space between them: John Doe -> JohnDoe
and in addition all sheets as well.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks