LinkBack URL
About LinkBacks
Hello:
Please refer to attached file.
I need to extract numerical part at the end of text in column B in column A.
Basically need formula in column A to extract numerical part at the end of text.
Let me know if you have any questions.
Thanks.
Riz
Hello:
Please refer to attached file.
I need to extract numerical part at the end of text in column B in column A.
Basically need formula in column A to extract numerical part at the end of text.
Let me know if you have any questions.
Thanks.
Riz
I am currently unable to open excel files (at work), can you give a few examples here please?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Are they always 5 digits (as shown in your example) ?
If so you could use this:
=RIGHT(B1,5)+0
then copy down.
Hope this helps.
Pete
Hello:
No, not necessary that it will have 5 digits.
Example : BACARDI ANEJO 750ML 28712, here i need to retrive 28712
99 APPLES 100ML 104099, here i need to get 104099
99 PEACHES LTR 104283 , 104283
Please let me know if you have any questions.
Thanks.
Riz
is there always a comma before the number, and is there always only 1 comma in the string?
Hello:
I am sorry but it will not have any comma,
BACARDI ANEJO 750ML 28712
99 APPLES 100ML 104099
99 PEACHES LTR 104283
NO COMMA
MAY BE BEST IF LAST SPACE character is found and numnerical number after the last space is the answer.
Thanks
Riz
Hi Riz,
I didn't notice it was you that was posting.
If the maximum number of digits is 6, you could use this:
=RIGHT(B1,7-FIND(" ",RIGHT(B1,7)))+0
Just change the 7 (twice) if the number of digits could be more than 6 (i.e. make it 1+ the largest number of digits).
Hope this helps.
Pete
Or, count the number of spaces (len()-len(substitute)), replace the last space with, say, @, ID where that is, and mid() from that point
Try this
Enter in A1 and copy down
Formula:
Please Login or Register to view this content.
v A B 1 12372 1800 REPOSADO 1.75 12372 2 28712 BACARDI ANEJO 750ML 28712 3 28712 BACARDI ANEJO 750ML 28712 4 104099 99 APPLES 100ML 104099 5 104283 99 PEACHES LTR 104283
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
Alkey, nice 1
Care to explain how that works?
Hi Ford,
There is not much to explaining to do. Simple LOOKUP function.
=-LOOKUP(1,-RIGHT(B1,COLUMN(1:1))) where COLUMN(1:1) here to replace {1,2,3,4,5,6,and so on} Nothing special
Hello Guys
Thanks to all but Alkey solution is great.
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks