I know that you can use the "Lower" function to convert an all capital word to all lower. Is there a way to convert an entire column at once or do you have to go cell by cell and dod the conversion?
thanks..................................matt
![]() |
|
|||||||
| General Software - [Answered] Excel text capitalization posted in the Software forums; I know that you can use the "Lower" function to convert an all capital word to all lower. Is there a way to convert an entire column at once or ... |
|
|
|
#1 |
|
Bronze Member
![]() Join Date: Apr 2006
Location: Connecticut
Posts: 94 PC Experience: Experienced
|
|
|
|
|
| Advertisement - Register to Remove | |
|
|
|
#2 |
|
Senior Security Analyst
![]() Join Date: Jan 2007
Location: texas, USA
Posts: 2,677 PC Experience: PC Illiterate
|
nope, it the same as LOWER, only you use UPPER.
Be sure to copy/paste special the results afterwards, or you will be getting the formula results, not the text value. thanks v
__________________
PCHF Prework / PCHF Rules / AVG / ATF / Housecall / NTRegOpt /Everest / PCHF Protect Your PC / PCHF Postwork M.C.S.A.M.C.P - MS Server 2k3, Network Architecture "Ask Bill why the string in function 9 is terminated by a dollar sign. Ask him, because he can't answer. Only I know that." - Gary Kildall ![]()
|
|
|
|
![]() |
| Bookmarks |
| Tags |
| answered, capitalization, excel, text |
| Thread Tools | |
| Display Modes | |
|
|











Be sure to copy/paste special the results afterwards, or you will be getting the formula results, not the text value. 














Linear Mode

