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