MID command

  • Thread starter Thread starter Michael May
  • Start date Start date
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with MID formula 4
Date Format 3
How to use index and match function for determining the value? 1
Formula error 4
How to determine the occurrence between periods? 1
CONCATENATE and SUMPRODUCT in a formula?? 2
Date mm/yy 2
How can I extract a month from Excel date? 6

Back
Top