Morning all, I have a column with text in (fluid, none fluid) over time the entries have become incorrect (mis spelt etc).
So I want to create a column that has a drop down selection instead (as I have a formula that uses that cell detail as prt of another operation). Which fails due to the point above. I know who to create a list(drop down) and a validation rule), but how can I get the current value into those cells? Without doing a manual cell by cell change? Circa 1600 rows...
any ideas. Cheers
So I want to create a column that has a drop down selection instead (as I have a formula that uses that cell detail as prt of another operation). Which fails due to the point above. I know who to create a list(drop down) and a validation rule), but how can I get the current value into those cells? Without doing a manual cell by cell change? Circa 1600 rows...
any ideas. Cheers