Adding a period to the "=LEFT()" function.

S

Stilla

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
 
D

Dave Peterson

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

maybe???


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
Click to expand...
 
B

Biff

hi!

Depends on what your exact formula is.

A1 = Stilla

=LEFT(A1)&"."

Returns: S.

Biff
 
Top