On Thu, 23 Feb 2006 08:25:16 -0800, "Carey Abercrombie" <Carey
wrote:

Can you take first/last names in a column and automatically format them to
initials for redacting purposes?

Sorry, small error in previous formula. Should be:

=REGEX.MID(I1,"\b\w")&REGEX.MID(I1,"\b\w",REGEX.CO UNT(I1,"\b\w+"))


--ron