Re first intials

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello From Steved

Iwas kindly given the below formula which is for 2 first
names.
=B2&". "&LEFT(C2,1)&", "& MID(C2,FIND(" ",C2)+1,1)

My question is I have over 1 thousand names, some have 1
for first name same have 2 for first and i found that
some have 3 first names, is the above formula capable to
be changed to reconize 1,2 or 3 first names and return
just the initials please. ie J,P,S

Thankyou.
 
Hi Steved!

You'd be better off parsing the data with Text to Columns
using either the "space" or "," (comma) delimiter.

Make it easy on yourself!

Biff
 
Thanks
-----Original Message-----
Hi Steved!

You'd be better off parsing the data with Text to Columns
using either the "space" or "," (comma) delimiter.

Make it easy on yourself!

Biff

.
Click to expand...
 
Converting names to initials is a very tricky business.
What about these:
Name Initial
Bob R (Robert)
Bill W (William)
Tony A (Anthony)
etc.?
 
association comes to mind good point but in my case
the Surname is the primary hence the initials are
secondary.
 
Back
Top