Assume your names are in the range A1:A1000, enter this formula in B1 (array
formula so enter it with Ctrl+Shift+Enter) and drag down:
=CONCATENATE(A1,REPT(".",MAX(LEN($A$1:$A$1000))-LEN(A1)))
--
Regards,
Dave
"Renee R." wrote:
For example:
brian.........
angela......
bob..........
|