in B3

=A3

& use a custom format of MMM

"Connie Martin" wrote:

In A3 there's a date, in date format: May-24-06. In B3 I would like a
formula that would insert MAY, picking up the month from A3. If the date in
A3 is Apr-18-06, then I would like B3 to yield APR, and so on. Connie