Macro to remove text from beginning of line
I'd like to know if someone may be able to help me with a macro. I have a spreadsheet that has over 14,000 entries. One of the columns has information like this:
Red w/yellow stripes
dark green w/purple polka dots
What I need to do is to remove everything in front of yellow stripes or purple polka dots. The columns need to look like this:
purple polka dots
So, in essence I need to find the w/ and then remove everything in front of the w/ and the w/ as well.
I don't even know if this is possible, but if anyone could help I would most appreciate it. Thank you.
Last edited by galetondesigns; 11-24-2008 at 11:34 AM.
Reason: Title Change
Welcome to the forum.
Please read the Forum Rules about thread titles, and then edit yours to be descriptive of your problem.
I guess from the lack of responses there's no way to do this. Thanks anyway
Take a look at text to columns. The delimiter would be "/"
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1