Forum

Notifications
Clear all

Delete a string in a cell that matches a string in a second cell.

3 Posts
2 Users
0 Reactions
61 Views
(@frits-erasmus)
Posts: 5
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
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Frits

In cell D1 enter : =TRIM(SUBSTITUTE(A1,C1,""))

Hope this helps.

Sunny

 
Posted : 26/04/2019 7:07 pm
(@frits-erasmus)
Posts: 5
Topic starter
 

@SunnyKow,

Thanks, it works a charm!!

That problem solved!!

 
Posted : 04/05/2019 2:35 am
Share: