CHANGE CASE COMMAND IN MICROSOFT EXCEL
Microsoft Word contains the command of CHANGE CASE which is very useful, but
Microsoft Excel does not contain this command due to which its too much difficult as rewrite the whole content of a cell. Cant this command be available in Microsoft Excel too, I think its not hard for Microsoft Corporation. Or if this command is available in Microsoft Excel what is the command. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
CHANGE CASE COMMAND IN MICROSOFT EXCEL
No, there is not an exactly equivalent command, but try the UPPER fiunction.
-- David Biddulph "Wahaish" wrote in message ... Microsoft Word contains the command of CHANGE CASE which is very useful, but Microsoft Excel does not contain this command due to which its too much difficult as rewrite the whole content of a cell. Cant this command be available in Microsoft Excel too, I think its not hard for Microsoft Corporation. Or if this command is available in Microsoft Excel what is the command. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
CHANGE CASE COMMAND IN MICROSOFT EXCEL
Until MS gets around to making Excel into a word processing application see
help on UPPER, LOWER and PROPER functions. Or store this macro for use on a range of cells. Sub TextConvert() 'By Ivan F Moala 'will change the text that you have selected, 'if no text is selected it will change the whole sheet Dim ocell As Range Dim Ans As String Ans = Application.InputBox("Type in Letter" & vbCr & _ "(L)owercase, (U)ppercase, (P)ropercase ") If Ans = "" Then Exit Sub For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2) Select Case UCase(Ans) Case "L": ocell = LCase(ocell.Formula) Case "U": ocell = UCase(ocell.Formula) Case "P": ocell = Application.Proper(ocell.Formula) End Select Next End Sub Gord Dibben MS Excel MVP On Sat, 13 Dec 2008 01:57:00 -0800, Wahaish wrote: Microsoft Word contains the command of CHANGE CASE which is very useful, but Microsoft Excel does not contain this command due to which its too much difficult as rewrite the whole content of a cell. Cant this command be available in Microsoft Excel too, I think its not hard for Microsoft Corporation. Or if this command is available in Microsoft Excel what is the command. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...lic.excel.misc |
All times are GMT +1. The time now is 03:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com