Saving Excel to Text file

[BIGGByran]

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?

 

[Pete_UK]

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