View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Computer geek Computer geek is offline
external usenet poster
 
Posts: 6
Default Help with function

Hey Guys and Gals,

I need a little help with a function. I need to evaluate a cell and
determine if the 12 character is a "-" (dash). And if it is a dash I
need to strip it and if its not a dash I need to leave it alone. By
the way the 12th character is the last character so its 12th from the
left or 1st from the right. Seems to me I need to somehow nest a
certain function inside an IF function. Please help.