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