View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pemmert pemmert is offline
external usenet poster
 
Posts: 3
Default Need a Function to Remove Text

Is there a function (or other Excel ability) to remove, in a single cell,
text after a certain character such as "-" e.g. to return "US" for
"US-AF-MIL" or "dot" for "dot-com"?