Tab Delimited Problem

TheTSArt

New Member
Joined
Dec 3, 2009
Messages
2
Hello, I am using Excel 2004 for the Mac.

I need to create a tab delimited file, the problem is that one of the columns is for a product description, which in most cases exceeds the space of the cells in the column. Excel shows those fields that exceed the space with a series of ####s. (If I click on those fields, I can still see the original text, though.)

My problem is that when I save to tab delimited any cell in that state is exported as #####, not the original text. I have extended the column width as far as Excel will allow me, which helps some, but that still leaves a lot of cells with the ####s which have a lot of text.

Is there any way to force Excel to save out the original contents of those cells?

Thanks.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,971
How long is the text in that cell??
Have you tried setting the cell's Format>Alignment>WrapText?
 

TheTSArt

New Member
Joined
Dec 3, 2009
Messages
2
Thanks for responding... I checked Wrap Text, unfortunately it didn't help with my problem, but caused a different one to emerge where if the text is less than the cell space it is not shown at all (and not saved out either).

The longest of my cells may have about 50 words or so in them.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,748
Messages
5,626,633
Members
416,195
Latest member
tonmcg

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top