How can i specify a cell to have a fixed number of characters
 

I need to concatenate text from 4 cells so that in the final string the text
from each cell is padded up to a length of 40 characters.
any ideas?
--
john

How can i specify a cell to have a fixed number of characters
 

=left(a1&rept(" ",40),40)&left(b1&rept(" ",40),40) & .....

If you have numbers/dates, you may want:

=right(rept(" ",40)&text(a1,"mm/dd/yyyy"),40) & .....

john dunford wrote:

I need to concatenate text from 4 cells so that in the final string the text
from each cell is padded up to a length of 40 characters.
any ideas?
--
john

--

Dave Peterson