I know how to make a drop down list in a cell or cells by using data validation; but my question is it possible through some sort of formula to, instead of an entire column to take the input of a column and remove all bold items (or any other feature of an item) so that only the plain text items are left for the drop down? Trying to accomplish this without macros.
Thanks!
Joe
Bookmarks