Merging The first Charcter of 3 seperate Fields

paul29berks

Active Member
Joined
Mar 15, 2004
Messages
293
I have 3 seperate fields:

Firstname
Second name
Third name

I only require the first initial from each field. i.e

Firstname = Paul
Second Name = Dave
Third name = John

would be represented as PDJ

Can anyone help.

Thanks
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
Build a query expression:
=Left([FirstName],1) & Left([Second Name],1) & Left([Third Name],1)

Denis
 

Watch MrExcel Video

Forum statistics

Threads
1,118,540
Messages
5,572,791
Members
412,484
Latest member
deezina07
Top