| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to columns. Only the first column appears in the wizard.
In Step1 are you able to view more than l record?
If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to columns. Only the first column appears in the wizard.
Hi Jacob
No - the second record never appears. I have discovered the cause. Text to columns does not recognise entries that have been separated into rows in the cell using ALT-ENTER. Now my challenge is to find a way to automatically remove a high volume of ALT-ENTER entries. Any ideas anyone? Thanks "Jacob Skaria" wrote: In Step1 are you able to view more than l record? If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to columns. Only the first column appears in the wizard.
Use CLEAN function to remove the Alt+Enter characters
CLEAN(A1) -- If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: Hi Jacob No - the second record never appears. I have discovered the cause. Text to columns does not recognise entries that have been separated into rows in the cell using ALT-ENTER. Now my challenge is to find a way to automatically remove a high volume of ALT-ENTER entries. Any ideas anyone? Thanks "Jacob Skaria" wrote: In Step1 are you able to view more than l record? If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to columns. Only the first column appears in the wizard.
If you want to replace it with a space use the below function
A1 = your text with alt+enter =SUBSTITUTE(A1,CHAR(10)," ") If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: Hi Jacob No - the second record never appears. I have discovered the cause. Text to columns does not recognise entries that have been separated into rows in the cell using ALT-ENTER. Now my challenge is to find a way to automatically remove a high volume of ALT-ENTER entries. Any ideas anyone? Thanks "Jacob Skaria" wrote: In Step1 are you able to view more than l record? If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text to columns. Only the first column appears in the wizard.
Perfect. Thanks Jacob!
"Jacob Skaria" wrote: Use CLEAN function to remove the Alt+Enter characters CLEAN(A1) -- If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: Hi Jacob No - the second record never appears. I have discovered the cause. Text to columns does not recognise entries that have been separated into rows in the cell using ALT-ENTER. Now my challenge is to find a way to automatically remove a high volume of ALT-ENTER entries. Any ideas anyone? Thanks "Jacob Skaria" wrote: In Step1 are you able to view more than l record? If this post helps click Yes --------------- Jacob Skaria "Carpet" wrote: 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 |
| Reply |
| 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) | |||
Linear Mode
