Thread: left of symbol
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Papa Jonah Papa Jonah is offline
external usenet poster
 
Posts: 148
Default left of symbol

I want to use someting like the left command to identify the number to the
left of the first "/".
My intent is to identify the month entered in a cell (first digit or two to
the left of the first "/") so that I can then use if then statements to
automatically identify the quarter that the date falls in.

TIA
Papa