Removing all the characters before a specific character

Occasional Visitor
  • I have this list of phone numbers, some of them contain a zero, number, and a slash before the number, I want to give this command (in case there's this character "/" remove it and everything before it) for the purpose of obtaining the numbers only, how?
  • I tried the find and select command and typed "*/" in the Find field and typed a space in the select but it didn't work, why?excel comm.png

     

1 Reply
Hi,
I just tested it and it works. Assuming you tried to search for */ without the quotes. I did that and was able to achieve what you intended. Also, if you want to simply remove the prefix for the phone numbers, you can always do a text to columns and use a / delimiter. This does leave the rows that do not have the delimited intact. Hope this helps!

Best,
bp