LinkBack URL
About LinkBacks
Hi,
Attached is the excel file and wish to know (may be a formula) how to extract (from column E) only numbers (to column G), e.g,
s/inverse/2041/done 2041 (to be extracted to column G)
Regards
Sushil
Hi,
Attached is the excel file and wish to know (may be a formula) how to extract (from column E) only numbers (to column G), e.g,
s/inverse/2041/done 2041 (to be extracted to column G)
Regards
Sushil
A general formula to extract numbers from a stringentered as an array formula with Ctrl+Shift+Enter
Please Login or Register to view this content.
pull down as needed
Hi
Try this:
IS CSE formulaPlease Login or Register to view this content.
Regards
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Fotis, the best way to be spammed is to place your e-mail address on the forum
If your data is in same format s/inverse/4 digit/done, you can use
=MID(E8,11,4)+0
If the position is dependent try the below formula
=LOOKUP(9E300,--MID(E8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},E8&"0123456789")),ROW(A$1:A$30)))
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Haseeb A---thank you! Your =Lookup formula worked for my data!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks