I'm implementing a template in excel where each cell should have a validation. For instance:
I would like to include in a hidden way a formula in the cells from B8 to B1000 that, in case a user inserts a string, excel automatically erase all the space included.
I would like to control (without using data validation) that cells from C8 to C1000 only include data in the list (E, R T, H). This means that the only string admitted are those in the list
I would like to convert the cells to D8 to D1000 in Decimals. This means that in the case in which the user will include a number but in a text format (this is due to copy and paste from other files) excel will automatically convert those text into decimal.
How should I do?