I want to save an excel sheet to a text file, but I don't have the columns to
be tab. I would like it to have no spaces between columns. Ex
Name Col; Movie Col; Food Col;
Wayne Blane; Forest Gump; Sushi;

I would like to save that excel file to text and come out like this:
Name Col;Movie Col;Food Col;
Wayne Blane;Forest Gump;Sushi;

Can anyone help me?

You can join those columns together in one cell (perhaps on another
sheet) like this:

=Sheet1!A1&";"&Sheet1!B1&";"&Sheet1!C1&";"

and then copy down for as many rows as you need.

Then you can fix the values on this sheet before saving it as a text
file.

Hope this helps.

Pete

On Dec 10, 7:18*am, BIGGByran
wrote:
I want to save an excel sheet to a text file, but I don't have the columns to
be tab. I would like it to have no spaces between columns. Ex
Name Col; * * * * * Movie Col; * * * * * Food Col;
Wayne Blane; * * *Forest Gump; * * * Sushi;

I would like to save that excel file to text and come out like this:
Name Col;Movie Col;Food Col;
Wayne Blane;Forest Gump;Sushi;

Can anyone help me?