Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
upper case to lower case
Hi everyone, Got a small problem with excel. I need to convert some text from upper case to lower case, easy i hear you say.. The only problem is that the first letter of each word needs to be upper case. i.e TURBO DIESEL needs to be Turbo Diesel, this is just an example there are too many variations to do a simple find and relplace Any help would be appreciated Thanks Andy -- andy_ ------------------------------------------------------------------------ andy_'s Profile: http://www.excelforum.com/member.php...o&userid=32218 View this thread: http://www.excelforum.com/showthread...hreadid=519697 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
upper case to lower case
If the text that you want to convert is in A1
enter this in any cell you fancy. =PROPER(A1) I'll leave the rest to you. George Gee "andy_" wrote in message ... Hi everyone, Got a small problem with excel. I need to convert some text from upper case to lower case, easy i hear you say.. The only problem is that the first letter of each word needs to be upper case. i.e TURBO DIESEL needs to be Turbo Diesel, this is just an example there are too many variations to do a simple find and relplace Any help would be appreciated Thanks Andy -- andy_ ------------------------------------------------------------------------ andy_'s Profile: http://www.excelforum.com/member.php...o&userid=32218 View this thread: http://www.excelforum.com/showthread...hreadid=519697 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
upper case to lower case
Have a look at the PROPER function. If the all caps text is in A1 put in B1 =PROPER(A1) -- mphell0 ------------------------------------------------------------------------ mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153 View this thread: http://www.excelforum.com/showthread...hreadid=519697 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
upper case to lower case
Use the PROPER function to convert text to first letter uppercase text.
if your text is in column a, insert a column to the right and in B1 enter the formula =PROPER(A1). Enter the formula and copy it down the column to convert all of your uppercase text values in column A. Copy all the data in column B, select cell A1 and click EDIT in the menu, click PASTE SPECIAL and click the VALUES option button. Delete the formula column and you're back in business. The companion case convert functions are UPPER() and LOWER(), should you have a need to ever do that kind of conversion. -- Kevin Backmann "andy_" wrote: Hi everyone, Got a small problem with excel. I need to convert some text from upper case to lower case, easy i hear you say.. The only problem is that the first letter of each word needs to be upper case. i.e TURBO DIESEL needs to be Turbo Diesel, this is just an example there are too many variations to do a simple find and relplace Any help would be appreciated Thanks Andy -- andy_ ------------------------------------------------------------------------ andy_'s Profile: http://www.excelforum.com/member.php...o&userid=32218 View this thread: http://www.excelforum.com/showthread...hreadid=519697 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
upper case to lower case
great stuff, Thanks very much. -- andy_ ------------------------------------------------------------------------ andy_'s Profile: http://www.excelforum.com/member.php...o&userid=32218 View this thread: http://www.excelforum.com/showthread...hreadid=519697 |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
upper case to lower case
Hi Andy,
If you would prefer to do it all in the same text column(s) you would be better using a macro, and it would be a lot faster to use once you've set up some macros. Then you can select the entire column and convert it -- macro should be restricted to the used range and use of special cells will limit such selections by definition so that the user doesn't have to be concerned with limiting range of selection. Proper, and other Text changes -- Use of SpecialCells http://www.mvps.org/dmcritchie/excel/proper.htm You would get more out of newsgroups if you posted directly to newsgroups rather than through a web page, and if you searched Google and Google Groups before posting. Use of "forums" messes up web searching for all users by duplicating what is posted in newsgroups. . --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "andy_" wrote in message ... great stuff, Thanks very much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to use spellnumber formula | Excel Worksheet Functions | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |