M
Michael May
In cell A1 I have a date in the 'DD-MMM-YY' format and in
cell A2 I want to return the value 'Aug' using the
MID(A1,4,3) command. When I try this I get the value 16
which is, of course, MID(A1,4,3) of 38216, the numerical
value of 17-AUG-04.
I want to include the returned 'AUG' vlaue within a
Concatenate command.
cell A2 I want to return the value 'Aug' using the
MID(A1,4,3) command. When I try this I get the value 16
which is, of course, MID(A1,4,3) of 38216, the numerical
value of 17-AUG-04.
I want to include the returned 'AUG' vlaue within a
Concatenate command.