how to take only numbers from text?

are these numbers in a sequence or may be at a different positions in the text. like ABACCC 25,25,012, asdasdasd or AB, 25,01 AC 256, CC 25,25,012, asdas20, 23dasd

for your given example and assuming numbers are one after another then below should work

copy and paste below in B1 then hold control and shift then hit enter and release all three keys to make it array formula
=MID(A1,MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0),0),(MAX(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0)*ROW(INDIRECT("1:"&LEN(A1))))+1)-MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0),0))

Have you entered the formula with control shift and Enter. Or update your book where it seems to be not useful more over you haven't replied to post 2 and Have you checked the book updated in post 3

Update your actual data!

Originally Posted by hemesh

are these numbers in a sequence or may be at a different positions in the text. like ABACCC 25,25,012, asdasdasd or AB, 25,01 AC 256, CC 25,25,012, asdas20, 23dasd

all the time numbers in same positions my friend.
not different positions.

Originally Posted by hemesh

for your given example and assuming numbers are one after another then below should work

copy and paste below in B1 then hold control and shift then hit enter and release all three keys to make it array formula
=MID(A1,MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0),0),(MAX(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0)*ROW(INDIRECT("1:"&LEN(A1))))+1)-MATCH(TRUE,ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0),0))

Check attachment in post 3

Originally Posted by aaaaa34

no its not useful enough
i m sure u can find much better formula

what is the meaning of useful then?

That's What i asked you in post 2 as You can see 2014 ,20 and 902 are the numbers. What is the specific point you want your numbers to start I can see may be a comma or any specific sub text in text

try below in B1 Array entered
=MID(A1,FIND(",",A1)+2,(MAX(ISNUMBER(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)+0)*ROW(INDIRECT("1:"&LEN(A1)))))-FIND(",",A1))

in your text i could see that number you are expecting is after comma and comma comes only before number series to be taken and there is no numbers afterwards.

I still suggest you to upload a workbook with atleast 10-15 rows of data to work with.

Thanks for the feedback !

aaaaa34 I know that you started this thread - almost 5 years ago, but unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member (or a different question in your own thread) -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.