Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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 datatext 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" wrote: 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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
You did pretty good without a sample. This helped. I can go from here.
Thanks!!! "FSt1" wrote: 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 datatext 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" wrote: 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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to Columns
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 On Wed, 2 Apr 2008 12:40:01 -0700, Skydiver wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions |