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

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

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

I did this but no result:

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

Bikeman

Try:

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

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