Super easy question

[Dylan @ UAFC]

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

 

[Pete_UK]

=LEFT(A1,1)

will give you the letter "M", whereas:

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

will give you "artinez"

Hope this helps.

Pete

 

[Marcelo]

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:

 

[Glenn]

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().

 

[Shane Devenshire]

Hi,

The simplest you can use is

=LEFT(A1)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[xlmate]

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