I am trying to add blank spaces at the end of a value so that each cell
is the same length.

In column A, I have names:

A1
Jones
Smith
Richardson
Blacksmith

In column B, each cell is 19 char in length. I want each cell in B to =
the same cell in A (i.e B1=A1). However, I need them to all be the same
length. To do so, I think I have to add trailing spaces to the names so
they all are 19 char in length.

Is is possible to add trailing spaces automatically to make all the
values the same length (i.e. LEN(B1)=LEN(B2)=LEN(B3) etc)?

Thanks for any help!


--
JohnGuts
------------------------------------------------------------------------
JohnGuts's Profile: http://www.excelforum.com/member.php...o&userid=30174
View this thread: http://www.excelforum.com/showthread...hreadid=566432