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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,920
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,123,402
Messages
5,601,475
Members
414,452
Latest member
Dannysamworth

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