Getting initials from Given Names

  • Thread starter Thread starter Peter
  • Start date Start date
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
 
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
 
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...
 
Back
Top