Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change text case in excel without using formula like word?
In the Ms Word I type a name ( Shahid Ghafoor Mughal) and using shortcut key
SHIFT+F3 i can easily change it case like( SHAHID GHAFOOR MUGHAL) or other types and also from format in the menu. but in excel we can not chages text case as like shahid into Shahid or SHAHID or sHAHID help me how we can do. reply me at. Shahid Ghafoor Mughal |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change text case in excel without using formula like word?
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change text case in excel without using formula like word?
Hi Shahid, (reusing reply already used twice today) You need a macro to do what you want. A function can only return a value, so if you don't want the little dance routine to convert formulas to values and remove the original column, you would need to use a macro. With a macro all you need to do is select the cells to be converted. If the macro is properly written it will restrict itself to the used range (one way is with SpecialCells), then you can select entire columns or the entire worksheet. If it is not properly written converting a single column could take 3 minutes (65536 cells on 600mHz with 128MB RAM). You should hardly notice converting 4000 cells in a column. Proper, and other Text changes -- Use of SpecialCells http://www.mvps.org/dmcritchie/excel/proper.htm#proper conversions to uppercase and lowercase also on same page courtesy reply sent as requested, please be aware that you should be picking up your responses from where you posted.. --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm In the Ms Word I type a name ( Shahid Ghafoor Mughal) and using shortcut key SHIFT+F3 i can easily change it case like( SHAHID GHAFOOR MUGHAL) or other types and also from format in the menu. but in excel we can not chages text case as like shahid into Shahid or SHAHID or sHAHID reply me at. <see original message for email address |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert a number to text | Excel Discussion (Misc queries) | |||
Loop for VBA code? | Excel Worksheet Functions | |||
Change the text from lower case to upper case in an Excel work boo | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Spellnumber | Excel Worksheet Functions |