Combining numerical and drop-down text in a single cell
 

Hi!
I am trying to create a medication spreadsheet, and wish to combine
numerical data with drop-down text options in a single cell/column.

For example, I would enter 200 (as the strength of the drug), and then be
offered a drop-down list of the available units (eg mg, mcg, ml, mg/ml etc).

There will be no calculations performed on this column.
Have tried data validation, custom cell formatting and cell merging to no
avail. Do not wish to use seperate columns if possible