How to convert an excel sheet to txt with specific column size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I'm trying to convert an excel sheet to txt file but I need that the
columns have a specific size (lenght).

otherwise I have this:

column1 column2
151214521 20
152254 15

I I want this in on txt:

column1 column2
151214521 20
152254 15

Is it possible?

Regards,
marco
 
It's difficult to see in your post, but you could use a helper column with
formulas like:

=left(a1&rept(" ",25),25) & left(b1&Rept(" ",6),6)

If you needed 25 characters in the first field and 6 in the second.

Then copy that formula down as far as you need
Copy that column
paste into NotePad
Save in notepad to the text file you want.

If you have time/dates/money that need special formatting, you can embed =text()
into each portion of the formula:

=left(text(a1,"$#,##0.00")&rept(" ",25),25) & ...
 
Back
Top