| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to edit column data so that all but left most character remain
Assuming the column contains only First and Last names separated by a space,
no prefix's, suffix's, initials, etc............ =UPPER(LEFT(A1,1)&"."&MID(A1,FIND(" ",A1,1)+1,1)&".") Vaya con Dios, Chuck, CABGx3 "Max Prophet" wrote: How can to convert a column of names to first initials (capitalized) followed by a period? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
