Hi Donna,

If you don't want to ensure the formatting consistency the above macro provides vis-a-vis the colons, the code can be reduced, but it's not clear whether you want to enforce two spaces or whether you're concerned with keeping the SSID/SSN strings on the same lines as the numbers to which they relate. The above code (give it a try) does this - even the hyphens are of the non-breaking kind.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]