All I am trying to so in use a formula
to take a name
Martinez
and leave all the charcter off except the M
Please advise

=LEFT(A1,1)

will give you the letter "M", whereas:

=RIGHT(A1,LEN(A1)-1)

will give you "artinez"

Hope this helps.

Pete

On Nov 25, 4:23*pm, Dylan @ UAFC
wrote:
All I am trying to so in use a formula
to take a name
Martinez
and leave all the charcter off except the M
Please advise

If you are looking for the first carachter of a cell, use:

=left(a2,1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Dylan @ UAFC" escreveu:

All I am trying to so in use a formula
to take a name
Martinez
and leave all the charcter off except the M
Please advise

Dylan @ UAFC wrote:
All I am trying to so in use a formula
to take a name
Martinez
and leave all the charcter off except the M
Please advise

Look in the help file for LEFT().

Hi,

The simplest you can use is

=LEFT(A1)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Dylan @ UAFC" wrote:

All I am trying to so in use a formula
to take a name
Martinez
and leave all the charcter off except the M
Please advise

Assuming that Martinez is in Cell A2, place this formula in cell B2
=LEFT(A2,1).
this will extract the first character in a text.

Does this do waht you want?
Pls click Yes if this help

cheers

"Dylan @ UAFC" wrote:

All I am trying to so in use a formula
to take a name
Martinez
and leave all the charcter off except the M
Please advise