You're welcome. Thanks for the feedback.

Fred.

"Steve" wrote in message
...
Very nice. And clean too.

Thanks much,

Steve

"Fred Smith" wrote:

Use Substitute, as in:
=Substitute(P21,"/","")

Regards,
Fred

"Steve" wrote in message
...
I have days off in the P column in this format: Sat/Sun
I'm using them in another column in this format SatSun, so I'm using
this
formula:
=LEFT(P21,3)&RIGHT(P21,3), which produces SatSun
However, I have some days off that just have Sun, which produces
SunSun.
How can the formula be writen to produce SatSun when two days are
showing,
and only Sun when one day is showing ?

Thanks,

Steve

.