Formatting Text Cells

[JohnnyCat]

I have cells that have variable length text in them. I want to forma
the cell so the total length of the cell is 35 characters. In othe
words, after the text, I would like spaces following the text, so th
total number of characters will be 35.

Thanks for your help

 

[Frank Kabel]

Hi
you could use the following in a helper column:
=A1 & REPT(" ",35-LEN(A1))

 

[JohnnyCat]

Thanks for your quick reply.

I tried that and got the "#VALUE!" in the cell.

Also, it seems like for this solution I would have to put this formul
into a cell for every text entry (changing the reference cell) that
have to format. This will cause a problem because there are 1000s o
values

 

[Frank Kabel]

Hi
make this:
=A1 & REPT(" ",MAX(0,35-LEN(A1)))

 

[JohnnyCat]

Ok, that works but how can I apply this to all the cells? Withou
enntering a2, then a3, etc..

 

[Dave Peterson]

If those cells are all in one column, you could use a helper column and drag
that formula down as far as you need.