Increase Strings/bytes on a cell

A

Abbey

A column made of cells, each cell has uneven characters (could be 10,9,13
etc).... for uniformity I want all cells to return 20 Characters. How do i do
this?

The extras can be filled up with spaces.
 
D

David Biddulph

=REPT(" ",20-LEN(A1))&A1 if you want leading spaces
=A1&REPT(" ",20-LEN(A1)) if you want trailing spaces
 
Top