Hi there,

I have to enter words (choices from a survey) into a single cell (for every respondant) but have to retype every word in each respondant's cell (autocomplete will not complete every/multiple words). Is there a formula which will enable me to type '1' or '2' etc. which corresponds to a word which will then enter the words (in a single cell, perhaps separated by a comma) ?

Many thanks,
-AP