Subract data in one column from data in another column

[David Wess]

Column A has stock CUSIP, Column B has description plus CUSIP. I want to remove the CUSIP from Column B:

Example:

Column A:  G1151C101

Column B:  ACCENTURE PLC CLS A USD0.0000225 ACN G1151C101

Objective: remove G1151C101 from Column B

Can this be done, and if so, how?  Thanks.

[#2]

@David Wess 

It it always at the right, as variant you may add to column C

=LEFT(B1,LEN(B1)-LEN(A1)-1)

[#3]

@Sergei Baklan 

I cannot seem to get it to work - could I impose upon you to input it into my spreadsheet (attached)?

Thanks!

[#4 · Accepted solution]

@David Wess 

David, you have a lot of spaces at the end of the text. I removed them by TRIM

=LEFT(TRIM(F3),LEN(TRIM(F3))-LEN(TRIM(E3))-1)

see in G3 attached.

[#5]

@Sergei Baklan 

Thank you VERY much, sir, greatly appreciated!!

[#6]

@David Wess , you are welcome