Excel Formulas Help?

Question

I'am trying to make excel take the information that is put into a cell , find a 1-4 digit number that is found by the a certain word like.

Something 9921


Then somewhere find all the rest of the numbers like that and put them in a cell like so 921,2132,12321 and so forth

Answer 1

yes clicking
-data
-text to columns
-make sure delimited is chosed, click next
will work

if they all look like
something 9921
that is
text/space/number

it wont matter how long the word or the number is, as long as they are separated by a space. then you want to check mark next to Space (UNcheckmark the tab
-click finish and it should separate it all out for you the way you want.

Answer 2

If data in the same order u can go to
Data > text to colomns
then select fixed width option u can see the separator line between numbers and other characters