Excel - delete info from a cell found in anot

Solved/Closed
sssecasiu Posts 1 Registration date Sunday December 18, 2011 Status Member Last seen December 18, 2011 - Dec 18, 2011 at 08:06 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 20, 2011 at 09:25 AM
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

Related:

3 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 19, 2011 at 09:57 AM
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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 20, 2011 at 09:25 AM
Forgot to replace ; by ,.

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

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

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

Cheers!
RAhul :)
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,