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

=LEFT(A1,1)&"."

--
Kind regards,

Niek Otten

"Stilla" wrote in message
...
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

=LEFT(A1,1) & "."


"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

=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

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

hi!

Depends on what your exact formula is.

A1 = Stilla

=LEFT(A1)&"."

Returns: S.

Biff

"Stilla" wrote in message
...
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

THANK YOU!

"Biff" wrote:

hi!

Depends on what your exact formula is.

A1 = Stilla

=LEFT(A1)&"."

Returns: S.

Biff

"Stilla" wrote in message
...
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

=left(a1,1)&"."


--
taylorm
------------------------------------------------------------------------
taylorm's Profile: http://www.excelforum.com/member.php...o&userid=28892
View this thread: http://www.excelforum.com/showthread...hreadid=510266

THANK YOU!

"taylorm" wrote:


=left(a1,1)&"."


--
taylorm
------------------------------------------------------------------------
taylorm's Profile: http://www.excelforum.com/member.php...o&userid=28892
View this thread: http://www.excelforum.com/showthread...hreadid=510266