save as text in excel 2003

  • Thread starter Thread starter lightman
  • Start date Start date
L

lightman

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 save as Excel 2003 problem 6
Excel 2003 inserts quotes when saving SS as text and comma is pres 1
How do I save excel file in text format without columns? 1
Converting multiple numbers saved as text in excel 3
Why cant I save as a text file in excel? 1
How can I save a file as a comma-delimited text file in Excel? 1
saving an excel file as text without text in quotes 2
Numbers as text in excel 4

Back
Top