Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
61
Views
Topic starter
I have an extract from a database and in a row, I will have the name of a product including the product_code (Or not) various lengths as well.
I would like to "remove" / delete from the first string the characters in a cell next to it:
e.g.:
What I have
Cell A1 Cell C1
Adhesive Glue stick 12 mm super strength GS5006 GS5006
I would like to end up with
Cell A1 (Or Cell F1)
Adhesive Glue stick 12 mm super strength
I have 15000 rows.
Anyone that can perhaps help me with this challenge.
Regards
Frits
Posted : 26/04/2019 11:15 am
Hi Frits
In cell D1 enter : =TRIM(SUBSTITUTE(A1,C1,""))
Hope this helps.
Sunny
Posted : 26/04/2019 7:07 pm
Topic starter
Posted : 04/05/2019 2:35 am