Removing all the characters before a specific character

[HebaAlghareeb]

• 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?

[#2]

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