Making all text strings the same length

[rs56369]

I have a range A2:A50, each cell contains a different string of text. The longest of these strings is 34 characters (I used the =len() function). I would like to add spaces to the end of every other string in order to bring them up to 34 characters as well. Is there a way to do this without going through each cell and adding in the specific spaces. I will be copy/pasting this range into a another program and it is much easier to read if all text strings are the same length.

[daddylonglegs]

Try this formula in B2 copied down

=LEFT(A2&REPT(" ",34),34)

You can then copy the range B2:B50 and use Edit > Paste special > values to copy over column A

[rs56369]

That worked perfectly, thanks again!

[Majharul]

Is it possible to measure visual length of a cell? Suppose i've data like below...

My data i like to have them
ColA ColB ColC
iiiii .89 iiiii-----.89
zzzzz .65 zzzzz--.65

that means every cells text length will be visually same.