Hello Friends
I want to extract the number only inside the cell in light yellow cells.
thanks in advance
thilag
Hello Friends
I want to extract the number only inside the cell in light yellow cells.
thanks in advance
thilag
Try this and copy down:
Please Login or Register to view this content.
Try this, copied down...
'=LOOKUP(99^99,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),ROW($1:$10000)))) Courtesy of:*Ron Coderre
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
@ Beamer, I think column B contains the answer they want?
Another solution is
B2=MID(A1,MATCH(TRUE,INDEX(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0),0),),SUMPRODUCT((ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0)=TRUE)*1))+0
Formula:Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
@FDibbins yeah that makes sense
Hello Ford
Your formula is working perfect thanks
Hello Beamer
Ford is correct Column B is required result to be done by formula.
thanks in advance
thilag
Hello Ankur
Your formula working prefect thanks for it.
thilag
Glad to help you dear
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks