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