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

Question

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

Configuration: Windows 7 / Safari 535.7

TrowaD · Answer

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

sssecasiu · Answer

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,

RWomanizer · Answer

Use the following Fomula it will helps you:

=REPLACE(F2,FIND(C2,F2),LEN(C2),"")

Cheers!
RAhul :)

Excel - delete info from a cell found in anot

3 responses

Similar discussions

Subscribe To Our Newsletter!