| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
intials from names
Hi
In A and B are the last and first names of patients. How can one display only the first letter of the name in the chart or perhaps in another cell? i.e. Smith John 126 pounds SJ 126 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
intials from names
A1 has: Smith
B1 has: John In D1 use =LEFT(A1)&LEFT(B1) to get: SJ best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "John" wrote in message ... Hi In A and B are the last and first names of patients. How can one display only the first letter of the name in the chart or perhaps in another cell? i.e. Smith John 126 pounds SJ 126 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| convert last, first names to intials | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| Extracting Intials from a name in a cell? | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Linear Mode
