UPPER text function
 

I want to change Normal Text on one worksheet to CAPITAL TEXT on a second
sheet to which it is linked. I have been able to do this by adding an
additional column to my second sheet, using the "UPPER" function and copying
all the data to the adjacent column. Can I apply this funtion directly to my
linked text ? I get assorted error messages when I try this. The formula
looks somehting like :
=Summary!G10+Upper(b3) where the first part is the name of the linked data,
and the second part attempting to convert it to capitals!
Any advice please? Many Thanks

=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to change Normal Text on one worksheet to CAPITAL
TEXT on a second
sheet to which it is linked. I have been able to do this
by adding an
additional column to my second sheet, using the "UPPER"
function and copying
all the data to the adjacent column. Can I apply this
funtion directly to my
linked text ? I get assorted error messages when I try
this. The formula
looks somehting like :
=Summary!G10+Upper(b3) where the first part is the name
of the linked data,
and the second part attempting to convert it to capitals!
Any advice please? Many Thanks
.

Perfect - You're a star-Thank you very much!!

"Jason Morin" wrote:

=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to change Normal Text on one worksheet to CAPITAL
TEXT on a second
sheet to which it is linked. I have been able to do this
by adding an
additional column to my second sheet, using the "UPPER"
function and copying
all the data to the adjacent column. Can I apply this
funtion directly to my
linked text ? I get assorted error messages when I try
this. The formula
looks somehting like :
=Summary!G10+Upper(b3) where the first part is the name
of the linked data,
and the second part attempting to convert it to capitals!
Any advice please? Many Thanks
.

I'm trying to do the same with a separate column of unlinked text, it isn't
working- and I end up with the following in the cell:
=My Text+UPPER(C3)
Bracketing as previous dosn't seem to work in this case??
Regards Graham

"Graham" wrote:

Perfect - You're a star-Thank you very much!!

"Jason Morin" wrote:

=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to change Normal Text on one worksheet to CAPITAL
TEXT on a second
sheet to which it is linked. I have been able to do this
by adding an
additional column to my second sheet, using the "UPPER"
function and copying
all the data to the adjacent column. Can I apply this
funtion directly to my
linked text ? I get assorted error messages when I try
this. The formula
looks somehting like :
=Summary!G10+Upper(b3) where the first part is the name
of the linked data,
and the second part attempting to convert it to capitals!
Any advice please? Many Thanks
.

Hi

Try something like
=MyText&UPPER(C3) eg ="Abcdef ghi jk"&UPPER(C3)

--
Andy.


"Graham" wrote in message
...
I'm trying to do the same with a separate column of unlinked text, it
isn't
working- and I end up with the following in the cell:
=My Text+UPPER(C3)
Bracketing as previous dosn't seem to work in this case??
Regards Graham

"Graham" wrote:

Perfect - You're a star-Thank you very much!!

"Jason Morin" wrote:

=UPPER(Summary!G10)

HTH
Jason
Atlanta, GA

-----Original Message-----
I want to change Normal Text on one worksheet to CAPITAL
TEXT on a second
sheet to which it is linked. I have been able to do this
by adding an
additional column to my second sheet, using the "UPPER"
function and copying
all the data to the adjacent column. Can I apply this
funtion directly to my
linked text ? I get assorted error messages when I try
this. The formula
looks somehting like :
=Summary!G10+Upper(b3) where the first part is the name
of the linked data,
and the second part attempting to convert it to capitals!
Any advice please? Many Thanks
.

Thank you Lady Layla, very helpful.

"Lady Layla" wrote:

Insert a column to the right of Col A
In cell B1 (assuming data is in A1) enter =UPPER(A1)
Copy this forumla down Col B until you have converted all cells
Select all cells in Col B that have data in them
Edit - Copy
Select cell A1 (Assuming this is where the data starts)
Edit Paste Special Values
Delete Col B


"Kim" wrote in message
...
: I'm sorry to sound like an idiot, but I don't understand how to use this
: function. Where am I supposed to put it? If I put it in the same cell as the
: one I want to change it doesn't work. I want all of column A to be
: uppercase. I just don't understand how these text functions work and the
: Help doesn't really explain it that well.