I have a column in which in every row have some text ending wwith numbers. Example
abc112
defg103
www2034
etc
How could I extract the numbers in next colums (or any other). Exaple
abc 112
defg 103
www 2034
If is non clear attaching sample
Thanks in advance
I don't know why is so hard to attach excel workbook instead of picture
Edit: If you want #N/A rather then 0 in case there is no number at the end of the word remove &0 and /10 from formula in D1
=LOOKUP(99^99; --RIGHT(A1&0; ROW($A$1:$A$30)))/10
Last edited by zbor; 02-28-2011 at 08:34 AM.
Never use Merged Cells in Excel
Thanks. This however works only for whole nimbers. If I apply it tonumbers with decimal point, I get something different. It is seen from the the attached file. How could solved this problem?
Maybe this helps:
@zbor
I like that...apparently the OP didn't get the "picture"
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks