View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A.S. A.S. is offline
external usenet poster
 
Posts: 79
Default extracting after a symbol

what would be the correct formula to use to extract before or after a
specific character.

For example, if one cell has "Afghanistan=AF". I need to extract everything
before the "=", so that the next cell will just read "Afghanistan". Thanks.