View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

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..........