=LEFT help

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hey guys,

I have this formula ="INSTYLE "&LEFT('Space Accrual'!
C31,FIND("-",'Space Accrual'!C31))

In cell C31 I have Jun-04

The my formula result is INSTYLE Jun-

Is there a formula that will return:
1. Everything in CAPS
2. Make the month completely spell it out, so instead
of Jun it will be JUNE
3. and get rid of "-"?


So my final answer would be INSTYLE JUNE
Thanks
 
John said:
I have this formula ="INSTYLE "&LEFT('Space Accrual'!C31,
FIND("-",'Space Accrual'!C31))

In cell C31 I have Jun-04

The my formula result is INSTYLE Jun- ....
So my final answer would be INSTYLE JUNE
Click to expand...

Whether C31 holds text or a date number, try

="INSTYLE "&UPPER(TEXT('Space Accrual'!C31,"mmmm"))
 
=Upper() - converts everything to uppercase

=Text(REF,"mmmm") returns June, if you want the year as well, use
=Text(REF,"mmmm yy")

The second Text equation should take care of the - for you if this data
is formatted as a date to begin with.

If not, use Ctrl+H, replace "-" with "".
 
Back
Top