Excel - delete info from a cell found in anot [Solved/Closed]

Report
Posts
1
Registration date
Sunday December 18, 2011
Status
Member
Last seen
December 18, 2011
-
Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 22, 2021
-
Hello,

Hello,

I need a solution for the following situation:

See attached screenshot from my Excel spreadsheet. I would like to know if there is a method of deleting part of the information from a cell that appears in another cell.

Example:
H78646733 from cell C2 can be found at the end of the text in cell F2 (Hamilton Khaki Belowzero Men's Watch H78646733). I would like to know if there is a possibility to delete to delete the code in cell F2 that appears in cell C2.

Thank you,
Sevastian

3 replies

Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 22, 2021
457
Hi Sevastian,

If the value of C2 is always at the end of the value in F2 seperated by a space then use this formula:
=LEFT(F2;LEN(F2)-(LEN(C2)+1))

Will this work for you?

Best regards,
Trowa
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2696
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
February 22, 2021
457
Forgot to replace ; by ,.

Formula should be:
LEFT(F2,LEN(F2)-(LEN(C2)+1))

And now you have two formula's to choose from.
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
116
Use the following Fomula it will helps you:

=REPLACE(F2,FIND(C2,F2),LEN(C2),"")

Cheers!
RAhul :)
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Hey,

This is great, thanks!
Regards,
Sevastian
Hi Trowa,

The problem is, e.g.: that cell C2 contains: 263-67/42 and cell F2 contains: Maxi Chronometer 43mm Model 263-67/42.

I need to only delete "263-67/42" from cell F2 and remain with "Maxi Chronometer 43mm Model".

The codes from column C are always different as well as the info from column F.

Any ideas?

Thanks,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!