Text to Columns from drop down list update
 

Hi

I need to perform a Text to Column conversion from a drop down list, but I
also need the extracted value to be updated if the value in the list is
changed. eg:

Drop down list has 2 values:

1. 4x16K
2. 8x8K

If the user selects 1 I can easily extract out to another cell the value 1
using Text to columns, however if the user then changes the choice to 2 the
text to columns extraction is not updated to 2.

Is there a way to update changes in the original cell using text to columns?

Or is there another way I can assign a value to a drop down menu choice in a
different cell while having text displayed in the drop down menu?

Thanks for any help,

Kurgan.