Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Question
Can you take first/last names in a column and automatically format them to
initials for redacting purposes? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Pivot Tables lose some formatting when Updated | Excel Discussion (Misc queries) | |||
Formatting Question | Excel Worksheet Functions | |||
Area Chart Formatting Question | Charts and Charting in Excel |