LinkBack URL
About LinkBacks
Hello,
I have a question on extract text from the middle. I have attached a file here. I need to extract the text after the - and drop all letters at the end.
Any help will be greatly appreciate.
Jackson
Hello,
I have a question on extract text from the middle. I have attached a file here. I need to extract the text after the - and drop all letters at the end.
Any help will be greatly appreciate.
Jackson
Last edited by jackson_hollon; 12-21-2016 at 03:41 PM.
Try this
Enter in B2 and copy down
Formula:
=SUBSTITUTE(LEFT(A2,LOOKUP(1,-MID(A2,COLUMN(A:XFC),1),COLUMN(A:XFC))),LEFT(A2,FIND("-",A2)),"")
v A B 1 What I have What I want 2 2015-300C 300 3 2015-0304A 0304 4 2015-CU176A CU176 5 2015-CU189BY CU189 6 2015-CU194A CU194 7 2015-CU196CM CU196 8 YD2015-165A 165 9 RS2015-165B 165 10 RD2015-172A 172 11 WX2015-176A 176
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hello Al,
Thanks for the reply. When I used your formula in the test file, it works. But my column in reality is in column K. When I used your formula it, it doesn't work.I do not know why to adjust it.
Thanks for the help.
Jackson
Change A2 to let say K2 leave the rest as is.
=SUBSTITUTE(LEFT(K2,LOOKUP(1,-MID(K2,COLUMN(A:XFC),1),COLUMN(A:XFC))),LEFT(K2,FIND("-",K2)),"")
Al,
It works.
Thank you very much.
Jackson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks