Re first intials

[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.

 

[Biff]

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

 

[Steved]

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

.

 

[Stephen Bye]

Converting names to initials is a very tricky business.
What about these:
Name Initial
Bob R (Robert)
Bill W (William)
Tony A (Anthony)
etc.?

 

[Steved]

association comes to mind good point but in my case
the Surname is the primary hence the initials are
secondary.