Forum Discussion
Removing all the characters before a specific character
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...
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
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