THANK YOU EVERYONE for the super fast reply!

"Dave Peterson" wrote:

=left(a1,1) & ". " & b1

maybe???



Stilla wrote:

I am converting a list of names to first initials using the =LEFT() function,
but can't figure out how to add a period afterthe first initial?

Is there a way to adjust this formula, or another one that would add a period?

Thanks so much.

Stilla

--

Dave Peterson