?B?R2FyeScncyBTdHVkZW50?= wrote
You can combine the cells into a single cell solution
if this is what you need.
Given what we have in place, that would be one long formula, would it not?
And I wouldn't know how.
I use another formula to display the result, anyway:
="**Deliver "&TEXT(G89,"dddd, mmm d")&" Please**"
where G89 now contains the former D1 CHOOSE() formula
I will live with the 4-cell variety since it doesn't interfere with the
look and feel of my sheet. I've made the fontcolor of those cells white so
a viewer won't see them.
--
David
|