save as text in excel 2003
 

have excel file with three columns
132422 la di da da sings, mark
334322 too la roo terrible, vocal

want to save as text file but the 2nd column must start at 8th charactor
spot in text file and third column must start at 44th charactor spot in the
text file.
2001 DON'T ROCK THE JUKEBOX ALAN JACKSON
2002 HOT HOT HOT BUSTER POINDEXTER
2003 SHOUT ISLEY BROTHERS
2004 BORN TO BE WILD STEPPENWOLF

Any clue how to save it into txt file like that?

save as text in excel 2003
 

In a second sheet you can put this formula in A1:

=TEXT(Sheet1!A1,"0000000") & Sheet1!B1 & REPT(" ",37-LEN(Sheet1!B1)) &
Sheet1!C1

Will make column A into 7 characters with leading zeroes, then column
B will be 37 characters long padded with spaces, and C1 will be from
character 44 onwards.

Copy this formula down as required, then have Sheet2 selected when you
do File | Save As with Text file as the file type, and then only that
sheet will be saved.

Hope this helps.

Pete

On Apr 25, 1:00*pm, lightman
wrote:
have excel file with three columns
132422 * * * * * *la di da da * * * * * sings, mark
334322 * * * * * *too la roo * * * * * *terrible, vocal

want to save as text file but the 2nd column must start at 8th charactor
spot in text file and third column must start at 44th charactor spot in the
text file.
2001 DON'T ROCK THE JUKEBOX * * * * * * * * ALAN JACKSON * * * * * * * *
2002 HOT HOT HOT * * * * * * * * * * * * * * * * * BUSTER POINDEXTER * *
2003 SHOUT * * * * * * * * * * * * * * * * * * * * * * ISLEY BROTHERS * * * * *
2004 BORN TO BE WILD * * * * * * * * * * * * * * STEPPENWOLF * * * * * *

Any clue how to save it into txt file like that?