how to force uppercase
 

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

how to force uppercase
 

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

"Ryan" wrote:

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

how to force uppercase
 

Did you mean to say:

=UPPER(Active!A4)

and formula-copy this down to Row 32 ?



Ryan Wrote:
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

"Ryan" wrote:

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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=483783