sperating a column in [x y z] to 3 colums x,y,z
 

ok, i have a colum in the format

[ # # # ]

is there a way to seperate that into 3 different columns of numbers?

for example

A
[ 38 96 58 ]

this is column A, i want that to be serated to

A B C
38 96 58



thanks in advance


--
true_atlantis
------------------------------------------------------------------------
true_atlantis's Profile: http://www.excelforum.com/member.php...o&userid=32957
View this thread: http://www.excelforum.com/showthread...hreadid=527835

sperating a column in [x y z] to 3 colums x,y,z
 

edit... paste special...transpose

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=527835

sperating a column in [x y z] to 3 colums x,y,z
 

Select the column
Data|Text to columns
Delimited (by a space character)
and skip the first and last columns.

true_atlantis wrote:

ok, i have a colum in the format

[ # # # ]

is there a way to seperate that into 3 different columns of numbers?

for example

A
[ 38 96 58 ]

this is column A, i want that to be serated to

A B C
38 96 58

thanks in advance

--
true_atlantis
------------------------------------------------------------------------
true_atlantis's Profile: http://www.excelforum.com/member.php...o&userid=32957
View this thread: http://www.excelforum.com/showthread...hreadid=527835

--

Dave Peterson