extract number in sequence

[crapit]

I have a series of number in a cell separate in sequence, How to I extract
them from cell a1 and put it in

A B C D
E F G
4 18 14 31 41 43 4 18 14
31 41 43

 

[T. Valko]

Use the Text to columns feature

Select cell A1
Goto the menu Data>Text to Columns
Select Delimited>Next>Space>Finish

 

[crapit]

wow, didnt know can use this method. Appreciate

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

wow, didnt know can use this method. Appreciate

 

[crapit]

from b1, c1, d1, e1, f1, g1, how to find if the number from each cell exists
in cell A1

 

[T. Valko]

One way:

=IF(COUNTIF(B1:G1,A1),"Yes","No")