Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel save as csv - force text qualifier on every text field | Excel Discussion (Misc queries) | |||
Save AS in Excel 2003 | Excel Discussion (Misc queries) | |||
The SAVE AS... option is gone in Excel 2003 | Excel Discussion (Misc queries) | |||
excel 2003 freeze when save as | Excel Discussion (Misc queries) | |||
Save prompt for Excel 2003 | Setting up and Configuration of Excel |