Excel qurey

  • Thread starter Thread starter HR
  • Start date Start date
H

HR

I am after a formula/method to extract several numerical
values from a single cell. The values could be a single
digit or many digits e.g. cell A1 has the following
entered in it 1(space)598(space)66328(space)654654

I would like to be able to extract each value and drop the
values into their own cells.

Any information/advice would be appreciated.
 
I think I've solved it.

Highlight the cell, and then select data/text to columns
then click delimited and space delimited.
 
Back
Top