separate a text cell to many number cells

K

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

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 A1:D1 and copy it, go to a new sheet, select B1 and do edit>paste
special and select transpose
 
Top