excel strip repeated text string from a cell
Posted on 2011-10-12
Hello all, in excel 2010 I need to find and strip the second occurrence of a repeated text string from a cell. This is not the same as stripping a single repeated word. I have a program that spits out repeated text strings en masse; there are many thousands of lines and I need to find only the repeated strings, delete these occurrences, and see the result in the next column.
E.g.: A1 contains "dog cat dog cat"
The result in B1 needs to be "dog cat " (note the trailing space). In my case there is a semicolon after the end of the repeated text but I suppose there could be a space as well. It would be nice if this is applicable to both instances, but I don't need the latter.
The string I need to strip can be more than one word long but it only occurs twice in the source cell. I would like to do this without a macro or add-in, if possible. makes things simpler since I further manipulate the text before copying it back to the other program.
Thanks in advance for helping me with this!