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

T

true_atlantis

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
 
D

Dave Peterson

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

true_atlantis said:
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
Click to expand...
 
Top