Community

Thank you Ben.

The data are too varied for the option of conditional expressions, as far as I could construct. Initials may not be all together in one spot, and include compound abbreviations.

I can repeat my replace-all say 3-4 times inside a macro, it may take a fraction longer to run.

But ...

I need to add full stops to initials in a series of records, but only for the records where the first character is an alpha. Other records not beginning with a name may also contain initials but these must not be touched.

so like example:
Smith, Robin John G H C, bla, bla...
Thompson, Ian P, bla ...