| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
=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 . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I combine text and a function in a single cell | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| Excel IF function for text | Excel Worksheet Functions | |||
| Help With The Upper Function | Excel Worksheet Functions | |||
Threaded Mode
