Text to Columns

[Skydiver]

I've "imported" data from an internal program at my job. The "imported"
information was obviously in separate columns, however in excel all of this
data is in column A. I'm trying to use "Data" > "Text to Columns" in order
to categorize the data in various columns. Help!

 

[FSt1]

hi
a sample of your data would have been nice.
not sure what you mean by "cateborize" but..
if the data was in columns, it should be seperated by a space(if not some
other delimiter) so high light the data in A then
data>text to columns...
first screen, select delimited.
second screen, select space
third screen, here you can preset some formats in the columns.
click ok.
should be done.

Post back if problems. include a sample of data.

Regards
FSt1

 

[Skydiver]

You did pretty good without a sample. This helped. I can go from here.
Thanks!!!

 

[Gord Dibben]

Help with what?

Depends upon what type of de-limiter(s) you have to parse the data.

You have neglected to add that bit of info or a sample of the data in column A


Gord Dibben MS Excel MVP