Thank you Guessed - that worked great. There is a lot of space where the text was converted to hidden text. Is it possible for a macro to automatically run to delete the hidden text once the dropdown has done its job?

Thank you again.