ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   deleting repeated text from a drop down box (https://www.excelbanter.com/excel-discussion-misc-queries/181661-deleting-repeated-text-drop-down-box.html)

LTaylor

deleting repeated text from a drop down box
 
I have drop down boxes that allow multiple choices. Here is the problem, if
more than one is chosen from the dropdown box and then you decide I only want
one and not the other and you go up to the formula bar and delete the text
you don't want and push enter it doubles the text in the cell. So, if I
choose green and blue and then don't want gree and I go to the formula bar
and hightlight the word green and delete it the cell with the drop down box
will now contain green, blue, blue

How do I get it from repeating text?


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com