4 replies
by dcrish
You can use these three functions:
=lower or =upper or =proper
Place the fomulas in a blank column. When you've copied the formula down, you may want to delete the original column. But so that the formula is no longer connected with that firstcolumn, you will need to do a Copy/Paste Special over the same column.
That is, you'll copy the column with the formula. Then, in the same columns, choose Paste Special command. Then choose Values from that dialog box.
write me if this isnot clear. moorech@cofc.edu
by tony porch
by khinton
try this
UPPER(text)
Text is the text you want converted to uppercase. Text can be a reference or text string.
Examples
UPPER("total") equals "TOTAL"
If E5 contains "yield", then:
UPPER(E5) equals "YIELD"
by tony porch
This discussion is closed to new replies.
Trending Windows Forum posts
Sort by Trending