View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Find - Replace help help

If you always want the first 3 characters from the left, then the
formula that Chuck gave you will do this, i.e.:

=LEFT(A1,3)

Hope this helps.

Pete