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

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

Guest

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?
 
=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) & .....
 
Back
Top