M
Maria
Please e-mail me back ASAP, if there's a way to do this in Excel... I know
WORD has it, but I can't seem to find it EXCEL
WORD has it, but I can't seem to find it EXCEL
TomHinkle said:look up the functions:
UPPER - converts to upper case
LOWER - converts to lower case
PROPER - converts to proper case (First Letter Of Each Word Capitalized)
David Billigmeier said:Try this, lets say your original values are in column A, in the range
A1:A1000. Place the formula =LOWER(A1) in B1 and drag all the way down to
B1000. Then, copy the B1:B1000 range, right-click on A1, click "Paste
Special..." and select "Values".
Use this technique to the cells you want to change, I used column's A and B
in this example.
Maria said:Please e-mail me back ASAP, if there's a way to do this in Excel... I know
WORD has it, but I can't seem to find it EXCEL
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.