LinkBack URL
About LinkBacks
Hi
I have the following text in cell A1
AAA - BBB
I would like to have a formula in another cell that returns
BBB
What formula should I use?
thanks
Hi
I have the following text in cell A1
AAA - BBB
I would like to have a formula in another cell that returns
BBB
What formula should I use?
thanks
Maybe this...
=RIGHT(A1,3)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks for the reply. I need a more generic formula as sometimes there are more than three characters after the hyphen and space and sometimes more than three characters before.
Would it be safe to say that you want to extract the last "word" in the string? Extract everything after the last space?
Maybe this...
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",50)),50))
Or try this one.
Enter formula in cell B1 and pull it to the right until you see blanks and then down
Formula:
Please Login or Register to view this content.
v A B C D 1 AAA - BBB AAA BBB 2 AAA - BBB - CCCC AAA BBB CCCC 3 ADDD - BB - CCCC ADDD BB CCCC
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
I would like to extract the string of words after the hyphen and space. thanks.
Does the formula in post #5 do what you want?
If not, post SEVERAL examples of what your data looks like.
Last edited by Tony Valko; 08-08-2016 at 07:36 PM.
Try this:Originally Posted by L.LEE
=RIGHT(A1,LEN(A1)-FIND("-",A1)-1)
assuming your text is in A1.
Hope this helps.
Pete
Thanks Tony. The formula given by Pete_UK works.
Here's another one that's a few keystrokes shorter...
=MID(A1,FIND("-",A1)+2,50)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks