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
|