| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to columns. Only the first column appears in the wizard.
Hi
I have a column of cells, each populated with entries delimited by semicolon. When I try to use text to columns, delimited by semicolon, only the first entry in each column appears in step 2 of the wizard. Instead of separating the column into multiple, the wizard is deleting all but the first entry in the cell. How do I prevent this? Note: This is not occurring due to selection of the 'Do not import column' option. The data dissappears before reaching that step. Thanks for any advice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text to Columns wizard greyed out | Excel Worksheet Functions | |||
| Count the number of times specific text appears in a column | Excel Worksheet Functions | |||
| Can you change the Text Import Wizard column options | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta 2 Error -- Text-to-Columns Wizard Data preview wha | Excel Discussion (Misc queries) | |||
| Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
Threaded Mode
