Jun 19 2019 10:27 AM
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.
Jun 19 2019 10:36 AM
It it always at the right, as variant you may add to column C
=LEFT(B1,LEN(B1)-LEN(A1)-1)
Jun 19 2019 11:01 AM
I cannot seem to get it to work - could I impose upon you to input it into my spreadsheet (attached)?
Thanks!
Jun 19 2019 11:09 AM
SolutionDavid, 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.
Jun 19 2019 11:58 AM
Jun 19 2019 01:19 PM
@David Wess , you are welcome
Jun 19 2019 11:09 AM
SolutionDavid, 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.