Getting initials from Given Names

P

Peter

I have loaded an Excel spreadsheet from a database using a
query and have a column which lists Given Names. I have
another column for initials and am wondering if these can
be created automatically from the Names column.

Any ideas?

Thanks
 
B

Biff

Hi Peter,

It depends on how they are setup and how you want them
displayed.

John Smith:

=LEFT(A1,1)&" "&MID(A1,FIND(" ",A1)+1,1)

Returns J S

Smith,John:

=LEFT(A1,1)&" "&MID(A1,FIND(",",A1)+1,1)

Returns S J

Smith,John:

=MID(A1,FIND(",",A1)+1,1)&LEFT(A1,1)

Returns JS

Biff
 
P

Peter

Thanks Biff, that helps a lot
-----Original Message-----
Hi Peter,

It depends on how they are setup and how you want them
displayed.

John Smith:

=LEFT(A1,1)&" "&MID(A1,FIND(" ",A1)+1,1)

Returns J S

Smith,John:

=LEFT(A1,1)&" "&MID(A1,FIND(",",A1)+1,1)

Returns S J

Smith,John:

=MID(A1,FIND(",",A1)+1,1)&LEFT(A1,1)

Returns JS

Biff

.
Click to expand...
 
Top