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