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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

one cell to many 2
Excel VBA For excel 0
How do I increase viewable cell character count limit in Excel? 2
Merged Cells when copying a table from Word to Excel 1
setting a cell length limit 1
Cut the last 20 characters out of a text string 4
check first 3 characters of a cell and compare to a table 4
How can I increase the number of text characters in a cell 2

Top