Good morning,
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
or
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:
Yellow stripes
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.
Bookmarks