[Answered] Excel text capitalization

BluesMatt · 03-28-2007

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

valis · 03-31-2007

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

03-28-2007	#1
BluesMatt Bronze Member Join Date: Apr 2006 Location: Connecticut Posts: 94 PC Experience: Experienced	[Answered] Excel text capitalization 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

03-31-2007	#2
valis 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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode