Hi guys,
is there any way I can format a cell so that when text is entered into it as CAPS or lower case, they are always automatically converted to UPPER CASE.
I tried the =UPPER function but this does not work as its a circular function when applying it to itself. I know I could use this function to display the desired results in another column, but I would really rather only have the one column if possible.
Sorry if this is a bit basic but I'm struggling with this one.
thanks in advance
is there any way I can format a cell so that when text is entered into it as CAPS or lower case, they are always automatically converted to UPPER CASE.
I tried the =UPPER function but this does not work as its a circular function when applying it to itself. I know I could use this function to display the desired results in another column, but I would really rather only have the one column if possible.
Sorry if this is a bit basic but I'm struggling with this one.
thanks in advance