Hi.
This is a simple formula that excel gives me when i use the list box function from the data validation:
='Sheet1'!$C$2:$C$73
My question is, can i add an additional formula to this formula?
I would like that the cell should automatically convert any data entered into uppercase.
*I am trying to avoid macros.

Thanks