I imported a database into an Excel spreadsheet. The middle initials in the
names don't have periods after them. Is there a wildcard character that I
can use to replace initials without periods to initials with periods?
One way:
Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr
Then use this formula:
=REGEX.SUBSTITUTE(A1,"([A-Z])\s","[1]. ")
Note the <space> after the <.> in the last argument of the formula.
In this algorithm, a "middle initial" is defined as a capital letter followed
by a space and preceded by something that is not a letter, number or
underscore. If your data differs from that, post back.
So multiple initials in a name will have a <.> inserted.
A J Fitz A. J. Fitz
Mary R Scots Mary R. Scots
Eskimo A B Joe Eskimo A. B. Joe
John Doe John Doe
--ron