how to force uppercase

[Guest]

Hey Everybody,

Question for you all ... i want to be able to set a column to force
uppercase from another tab in the same worksheet ... this is what i have ...

=UPPER(ACTIVE!A4:A32)

where active is the name of tab i want this to take place ...

let me know ...

Thanks,
Ryan

 

[Guest]

The problem is i get "VALUE" when i do this ... it works if i put it in the
same tab ... but wont pull from the other ones. Somebody tell me if this
possible. I have a "VARS" tab where i want my variables.

Thanks for the help

 

[Bryan Hessey]

Did you mean to say:

=UPPER(Active!A4)

and formula-copy this down to Row 32 ?