UPPER text function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Area to include text box 10
Formatting cells to only upper case 5
UPPER CASE 1
Excel: how to convert text to upper case upon entry? 13
Copy text only, not formula 1
Change range in capital letters on load 1
CHANGE LOWER CASE TO UPPER CASE? 1
Returning the month (mmm) from cell in date format dd/mm/yyyy 1

Back
Top