Increase Strings/bytes on a cell
 

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.

Increase Strings/bytes on a cell
 

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

"Abbey" wrote in message
...
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.