Excel qurey

[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.

 

[HR]

I think I've solved it.

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

 

[Arvi Laanemets]

Hi

Data.TextToColumns with space as delimiter