Assuming the First and Last names are separated by a "space".....

=LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1) will give you the first character
of each name......

="?"&MID(A1,2,FIND(" ",A1,1)-1)&"?"&MID(A1,FIND(" ",A1,1)+2,99) will return
both names separated by a space, but with the first character of each name
replaced with a question mark.

Vaya con Dios,
Chuck, CABGx3



Vaya con Dios,
Chuck, CABGx3



"Carey Abercrombie" wrote:

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