How can I turn checkbox entries into a sentence

[EMPM]

I can't figure this out. How can I turn the selections made in a check box field into a sentence. For instance in a field I call "Flooring" I check off hardwood, ceramic and carpet and shows up in another filed as "Flooring is hardwood, ceramic and carpet".

[Stuart Taylor]

"Flooring is " & Substitute ( Flooring ; "¶" ; ", " )

will return "Flooring is hardwood, ceramic, carpet"

you could test for the "position" of the last ", " and replace it with " and "

[EMPM]

Thank you so much for answering so quickly. I'm not very strong with calculations. Could you elaborate a bit more what I am to do. It is much appreciated.

[EMPM]

It works perfectly. Thank You