Intitials

[Bikeman17]

I want to extract the initials from John Smith. I've been able to get the J by doing this: Left(Name,1). But I am having difficulties to get the S. Any help would be nice!

Bikeman

[danjacoby]

Use the "MiddleWords" function to get to the second word.

Use the "Left" function to choose the first letter of that word.

[Bikeman17]

I did this but no result:

Left(Name,1) & MiddleWords(Name,2,Left(Name,1))

Bikeman

[BobWeaver]

Try:

Left(Name,1)&Left(MiddleWords(Name,2,1),1)

[Lee Smith]

Hi Bikeman

Here is a little variation to Bob's calculation incase you have initials in there too.

Left(Employee,1)&

Left(RightWords(Employee,1),1)

HTH

Lee