I have a stock list and the descriptions are not well captured.
The brand is both in the beginning and at the end and the second one. Only if at the END must be deleted.
The string is in also available in another column.
I can as step one remove both same strings and as step 2 concatenate that string by adding the brand in the beginning.
If there is an easier way, I will appreciate some help as the file has 15,000 rows.
Thanking in advance!!
Frits
Hi Frits
It would be better if you can attach some examples and their expected results. It will help us understand your needs better.
Your idea of removing and then concatenating the text looks good and is easier
You can also try this if you want:
Cell A1 contains GS5006 Adhesive Glue stick 12 mm super strength GS5006
Cell B1 contains GS5006 (brand to replace)
In cell C1 enter =REPLACE(A1,FIND(B1,A1,FIND(B1,A1)+2),LEN(B1),"")
I prefer your method.
Sunny
If it's always at the end with a space preceding it, you could also use:
=SUBSTITUTE(A1," "&B1,"")
