+ Reply to Thread
Results 1 to 3 of 3

how to force uppercase

  1. #1
    Ryan
    Guest

    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

  2. #2
    Ryan
    Guest

    RE: 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


  3. #3
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Did you mean to say:

    =UPPER(Active!A4)

    and formula-copy this down to Row 32 ?



    Quote Originally Posted by Ryan
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1