View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marvin P. Winterbottom
 
Posts: n/a
Default Can I match the beginning of text in an Excel cell?

=left(a1,1)


"David Greggs" wrote:

I am trying to match the beginning of a text string in a cell, so that I can
replace a character only at the beginning and not anywhere else. I have done
this with regular expressesions, such as ^ in the past. Is this possible in
Excel?