Hi, I have a column with text that begins with
R1 some text
R2 some text
etc
R10 some text
R11 some text
How can I extract the first number (1,2) but also the second if there is a second (10,11) so the output would be:
1
2
10
11
I tired =RIGHT(LEFT(A2,2),1) but it doesn't give me 10 and 11 (only 1)
Try this instead:
=MID(A2,2,(FIND(" ",A2)-2))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Or this:
=--MID(A2,2,2)
Or just this, IF your format will always be the same...
=--MID(K2,2,2)
To catch the cells with no numbers...
=IFERROR(--MID(K2,2,2),"")
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
perfect. Thanks!
or this one, but you will need add-in for Excel 2010 : PowerQuery
Doesn't matter how long is your number
source Numbers R1 some text 1 R2 some text 2 R5 some text 5 R10 some text 10 R11 some text 11 R100 some text 100 R1000 sometext 1000 R10000 some text 10000
Last edited by sandy666; 10-02-2017 at 02:50 AM.
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks