| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract letters from a cell
Hi,
We received a list of names of persons we need to sent letters to. The last name is okay in a separate cell. The first , 2nd (and 3rd) names are all in one cell, but we want to extract only the initials. The cells are not consistent as some cells have the full first name and then 2nd and/or 3rd initial(s), some also have the full 2nd name. In worst case scenario I thought of only extracting the initial of the first name. Examples: Diane M. needs to be DM Laura Mary needs to be LM Laura Mary C. needs to be LMC If any of you can help me it will be great. Thanks, Lupe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| letters cut off in cell | Excel Worksheet Functions | |||
| Please help: Extract some information from a cell | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
