View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Super easy question

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