Forum Discussion
Solved
Subract data in one column from data in another column
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.
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 Replies
It it always at the right, as variant you may add to column C
=LEFT(B1,LEN(B1)-LEN(A1)-1)
I cannot seem to get it to work - could I impose upon you to input it into my spreadsheet (attached)?
Thanks!
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.
