How DO I set a fixed length column in Excel 4

[mdl2]

How do I set a fixed length text column in excel. I want first name and last name to export as 30 characters each regardless if there are less charaters entered.


Thanks

 

[SkipVought]

Hi,

Do you want the COLUMN WIDTH set or do you want the VALUE that is entered. padded with SPACES to a length of 30?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[mdl2]

I want the VALUE that is entered. padded with SPACES to a length of 30.

 

[SkipVought]

This cannot be done on the sheet without VBA code.

You can, however set up a formula in another column like this if your data is entered in A1
[tt]
=A1&Left(" ",30-Len(A1))
[/tt]


Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[GlennUK]

Hi Skip,

your formula would be easier to read if you generated the spaces like this:

=A1&REPT(" ",30-LEN(A1))

No offemce mate.

Cheers, Glenn.

 

[CNS4us]

Great additional thought Glenn. You guys are awesome! Here I thought I knew some stuff about Excel. I am constantly surprised by my ignorance.

"The more you know, the more you know you don't"
- my own little quote I like.

Cheers!!!!!!

 

[SkipVought]

Glenn,

Thanx! I have never used REPT, but I will now!

==> *

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[GlennUK]

Thanks for the stars guys

I'll have a beer tonight to celebrate.

Cheers, Glenn