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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get the following data ... How to create the formula for below 1
Sumproduct Problem 4
How to remove dashes and slashes form a sequence of numbers & lett 3
Extracting data from a text string: 6
<<Extracting the desired data with an formula>> 10
need help finding most common number and so on 2
Number Match Formula? 7
Excel Conditional Formatting 1

Back
Top