extract number in sequence

  • Thread starter Thread starter crapit
  • Start date Start date
C

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
 
Use the Text to columns feature

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