Column A has stock CUSIP, Column B has description plus CUSIP. I want to remove the CUSIP from Column B:
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.
View best response
It it always at the right, as variant you may add to column C
I cannot seem to get it to work - could I impose upon you to input it into my spreadsheet (attached)?
David, you have a lot of spaces at the end of the text. I removed them by TRIM
see in G3 attached.
Thank you VERY much, sir, greatly appreciated!!
@David Wess , you are welcome