intials from names

J

John

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
 
B

Bernard Liengme

A1 has: Smith
B1 has: John
In D1 use =LEFT(A1)&LEFT(B1) to get: SJ
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Grouping Names in Mail Merge 0
One extra x axis item that wont go away - can anyone help? 3
VBA - exporting serial letters to single documents 0
Drop down list control value in vba 2
Working on birthday "book" for my wife and having layout/editing trouble 0
sideways stacked bar charts with line series on the same axis 0
Matching Names 7

Top