Hello,
I am looking for an excel formula to extract the last digits from a text string.
Example: RAC-170422242-OFFMAX105
I would need to extract 105 from that string.
It's not always the last 3 characters that i need. Sometimes the string can look like this:
RADF-36564-WAL24
In this case I need to extract 24 from that string
Any help would be much appreciated.
Thanks
Based on your very small sample, this is all I can come up with
B1 copied down >> =RIGHT(A1,LEN(MID(A1,FIND("@",SUBSTITUTE(A1,"-","@",2))+1,LEN(A1)))-MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A1,FIND("@",SUBSTITUTE(A1,"-","@",2))+1,LEN(A1))&"0123456789"))+1)
Please Login or Register to view this content.
HTH
Regards, Jeff
A1 is string, Try:
=MAX(IFERROR(--RIGHT(A1,ROW(INDIRECT("1:"&LEN(A1)))),""))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Quang PT
They both seem to work great. Thank you very much
Try this
Formula:
Please Login or Register to view this content.
v A B 1 RAC-170422242-OFFMAX105 105 2 RADF-36564-WAL24 24
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
Really good one. Works like a charm. I changed the Row part to ROW(A$1:A$4) since there will never be more than 4 digits at the end. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks