| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 0 bytes | Excel Discussion (Misc queries) | |||
| Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
| How many bytes? | Excel Discussion (Misc queries) | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| file 0 bytes | Excel Discussion (Misc queries) | |||
Linear Mode
