I want to Concatenate a series of choices the user will make from six cells containing lists.
So I added the formula: =J5&"; "&J6&"; "&J7&"; "&J8&"; "&J9&"; "&J10
I added the semicolon and space so each choice would be separated.
Ex. Item A; Item B; Item D; and so on.
However the user may only need to one or two items. So the Concatenated cell would look like:
Item A; Item B; ; ; ;
How can I remove the extra semicolons and spaces at the end?
I would like to avoid a Macro if possible...
Thanks in advance.
Bookmarks