Import wizard limitation

I'm importing a file that has records over 2000 characters long, and using
the wizard to break it down into columns. But there seems to be a limit at
character 2,374, so all characters after that will be put into a single cell
in the spreadsheet. Is this an actual Excel limit, and is there a way to
get around this limit, or some other strategy, including using other
applications.

Many thanks in advance.

Are you sure that you didn't exceed the number of columns/fields in a worksheet
(256)?



Sirocco wrote:
>
> I'm importing a file that has records over 2000 characters long, and using
> the wizard to break it down into columns. But there seems to be a limit at
> character 2,374, so all characters after that will be put into a single cell
> in the spreadsheet. Is this an actual Excel limit, and is there a way to
> get around this limit, or some other strategy, including using other
> applications.
>
> Many thanks in advance.

--

Dave Peterson