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

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

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

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

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

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