View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default How to retrieve character from a string for excel?

Does anyone know how to retrieve the first two character from a string for
excel?
such as there is a word in Cell B2 = "Choice", then in Cell B1, which
display only "Ch".
Does anyone have any suggestion?
Thank you for any suggestion
Eric