looking into a cell

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

i have a Jun-04 in cell A1

Is there a forulma that will look in cell A1 and return
JUNE?

if its Jul-03 it will return JULY

In other words... it will spell out the monuh

Ant
 
One way:

=A1

Format the cell with Format/Cells/Number/Custom mmmm
 
=Upper(text(A1,"mmmm"))

This formula basically returns June and capitalizes it.
 
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

Summing weekly values to fall into correct month 2
separating date and time 5
Lookup date between 2 dates 1
2 criterias in lookup 1
date format and the RIGHT function 2
Double CountIF 5
date format and the RIGHT function 1
COUNTIF headscratcher 6

Back
Top