How I can convert 21-05-2007 to text May ?

=text(a1,"mmm")
or
=text(a1,"mmmm")
if A1 contains the date.

Or you could just give the cell a custom format of:
MMM
or
MMMM

The date will still be in the cell (in the formula bar), but you'll see the
month (or month abbreviation).

Miguel wrote:

How I can convert 21-05-2007 to text May ?

--

Dave Peterson

=LOOKUP((MID(A1,FIND("-",A1,1)+1,2)*1),{1,2,3,4,5,6,7,8,9,10,11,12},{"Jan uary","February","March","April","May","June","Jul y","August","September","October","November","Dece mber"})

All on one line, watch out for word-wrap.

Vaya con Dios,
Chuck, CABGx3



"Miguel" wrote:

How I can convert 21-05-2007 to text May ?

Hi Chuck,

Thanks for your help but give me an error. Should replace "," by ";" ?
Thanks

Miguel

"CLR" wrote:

=LOOKUP((MID(A1,FIND("-",A1,1)+1,2)*1),{1,2,3,4,5,6,7,8,9,10,11,12},{"Jan uary","February","March","April","May","June","Jul y","August","September","October","November","Dece mber"})

All on one line, watch out for word-wrap.

Vaya con Dios,
Chuck, CABGx3



"Miguel" wrote:

How I can convert 21-05-2007 to text May ?

Could be..........if you're using other than a U.S. version of
Excel...........give it a try.

Vaya con Dios,
Chuck, CABGx3



"Miguel" wrote:

Hi Chuck,

Thanks for your help but give me an error. Should replace "," by ";" ?
Thanks

Miguel

"CLR" wrote:

=LOOKUP((MID(A1,FIND("-",A1,1)+1,2)*1),{1,2,3,4,5,6,7,8,9,10,11,12},{"Jan uary","February","March","April","May","June","Jul y","August","September","October","November","Dece mber"})

All on one line, watch out for word-wrap.

Vaya con Dios,
Chuck, CABGx3



"Miguel" wrote:

How I can convert 21-05-2007 to text May ?

did you try to use the cell formating to do this? If you need the date in
one field and to show May in another then you could have the date in one
cell, reference that from another cell and have the second one formated to
only show the MAY. You might have to change the way you put the date in
since the format of the date is generally recognized as the month first not
the day.

"Miguel" wrote:

How I can convert 21-05-2007 to text May ?

Hi

If I use Format Cells I will have a problem with pivot tables . I need to
transform a date in a pure text .
Thanks
Miguel

"Balzyone" wrote:

did you try to use the cell formating to do this? If you need the date in
one field and to show May in another then you could have the date in one
cell, reference that from another cell and have the second one formated to
only show the MAY. You might have to change the way you put the date in
since the format of the date is generally recognized as the month first not
the day.

"Miguel" wrote:

How I can convert 21-05-2007 to text May ?