separate a text cell to many number cells

[Khoshravan]

I copied a text from a web page to Cell A1 in excel. It looks like as
follows
a1=Height (in) 58 59 60

Now I want to separate to into 4 cells as follows:
B2=Height )in)
B3=58
B4=59
B5=60

I do remember once I had read a thread related to this issue before but I
cant find it now.
I think by combination of left and mid functions it is possible to perform
this task but the problem is about auto-detection of space between numbers
and I cant recall this part.

 

[Peo Sjoblom]

First of all make sure you don't have any data in column B, C and D
Then select the range, do data>text to columns, select fixed delimiter,
click next and double click on the delimiter line that is between Height and
(in), then click finish

Now select A11 and copy it, go to a new sheet, select B1 and do edit>paste
special and select transpose