Formatting Question
Can you take first/last names in a column and automatically format them to
initials for redacting purposes? |
Formatting Question
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? |
Formatting Question
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")®EX.MID(I1,"\b\w",REGEX.CO UNT(I1,"\b\w+")) --ron |
Formatting Question
WOW, THANKS VERY MUCH. EXACTLY WHAT I NEEDED.
CAREY "CLR" wrote: 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? |
Formatting Question
PERFECT. EXACTLY WHAT I NEEDED.
THANKS, CAREY "Ron Rosenfeld" wrote: 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")®EX.MID(I1,"\b\w",REGEX.CO UNT(I1,"\b\w+")) --ron |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com