separate a text cell to many number cells
 

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.

separate a text cell to many number cells
 

First of all make sure you don't have any data in column B, C and D
Then select the range, do datatext 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 editpaste
special and select transpose


--
Regards,

Peo Sjoblom


"Khoshravan" wrote in message
...
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.