Please help: splitting...

Thanks, RagDyer!

It worked perfectly. I did have to check "Other" instead of "Space" to
bring the values w/o the Y to the right columns...

I spent a great deal of time trying to come up with a formula and your
totally unexpected solution just blew me away.

I just love the internet. What a great community!

Henry

Appreciate the feed-back.

--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

<dervishme@comcast.net> wrote in message
news:1118089187.894254.126320@g49g2000cwa.googlegroups.com...
> Thanks, RagDyer!
>
> It worked perfectly. I did have to check "Other" instead of "Space" to
> bring the values w/o the Y to the right columns...
>
> I spent a great deal of time trying to come up with a formula and your
> totally unexpected solution just blew me away.
>
> I just love the internet. What a great community!
>
> Henry
>