How to preserve text formatting

[total21]

I have a colum of data, which as an example, looks something like this:

[TABLE="width: 527"]
<tbody>[TR]
[TD="class: xl63, width: 527"]0.33|third|1/3

When I do Data -> Text to columns it will work correctly, but this will turn into 0.33 third Jan-3

I dont need anything like Jan-3 and all cells need to be kept as they are. Is there any way to prevent that. I've tried formatting all cells as General or Text, but it does not work. 1/3 still gets changed to Jan-3.

Thanks. [/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

You're welcome.

 

[Rick Rothstein]

I think what OP is saying is you have mixed data down the column.
Some rows have only 2 or 3 delimiters
Some have many.

Ah, I see.

In the TTC window, you only see a preview of a few rows.
If that preview window doesn't contain a row with many delimters, then you only see a few of the resulting columns.
If you scroll down to a point where a row in the preview window contains many delimiters, THEN you can see many columns.

Yes, definitely a "flawed" implementation of a Data Preview window table... and I can find no way around this in order to force the table to show all the columns (except to, as you noted, scroll down to the row that will break out into the most columns).