Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Repeated Rows Constantly Amazed Excel Worksheet Functions 2 November 9th 06 10:45 AM
Printing text in a repeated cell/row that is longer than repeated Valerie Dyet Excel Discussion (Misc queries) 1 February 13th 06 03:27 AM
Deleting cells with repeated data petevang Excel Worksheet Functions 2 December 6th 05 10:27 PM
Editing Repeated Text Jonny Excel Worksheet Functions 2 November 3rd 05 11:52 AM
repeated text maria Excel Discussion (Misc queries) 2 February 10th 05 10:57 PM


All times are GMT +1. The time now is 01:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"