Increase Strings/bytes on a cell

  • Thread starter Thread starter Abbey
  • Start date Start date
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.
 
=REPT(" ",20-LEN(A1))&A1 if you want leading spaces
=A1&REPT(" ",20-LEN(A1)) if you want trailing spaces
 
Back
Top