If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Format text in Excel
How do I format LARGE CASE text to small case in excel 2002. Thanks Keith
|
#2
|
|||
|
|||
You need a small macro, or a formula in another cell, like
=LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#3
|
|||
|
|||
Please could you tell me how to do this? Thanks
"Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#4
|
|||
|
|||
If you have this in cell A1:
THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#5
|
|||
|
|||
I have 7000 addresses in my excel database, approximately 5000 are uppercase
text! I need to change them to lower case? is there a quick way without me having to edit them all individually? Thanks "Harald Staff" wrote in message ... If you have this in cell A1: THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#6
|
|||
|
|||
This does not work ?
"Harald Staff" wrote in message ... If you have this in cell A1: THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#7
|
|||
|
|||
Kez
Sub Lower_Case() 'David McRitchie, programming, 2003-03-07 Dim rng1 As Range, rng2 As Range, bigrange As Range Dim Cell As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual On Error Resume Next Set rng1 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeConstants)) Set rng2 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeFormulas)) On Error GoTo 0 If rng1 Is Nothing Then Set bigrange = rng2 ElseIf rng2 Is Nothing Then Set bigrange = rng1 Else Set bigrange = Union(rng1, rng2) End If If bigrange Is Nothing Then MsgBox "All cells in range are EMPTY" GoTo done End If For Each Cell In bigrange Cell.Formula = LCase(Cell.Formula) Next Cell done: Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On Fri, 10 Dec 2004 17:06:20 -0000, "kez" wrote: I have 7000 addresses in my excel database, approximately 5000 are uppercase text! I need to change them to lower case? is there a quick way without me having to edit them all individually? Thanks "Harald Staff" wrote in message ... If you have this in cell A1: THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#8
|
|||
|
|||
I read this as a question about wether my suggestion works or not. Yes it
does, at least it works perfectly fine on my computer. I don't find deliberate non-working sloutions amusing, so have no fear. Give it a try. I come in peace, take me to your leader. "kez" skrev i melding ... This does not work ? "Harald Staff" wrote in message ... If you have this in cell A1: THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#9
|
|||
|
|||
Hello Gorden
I am an absolute beginner to excel , what do I do with this ? Thanks Keith "Gord Dibben" gorddibbATshawDOTca wrote in message ... Kez Sub Lower_Case() 'David McRitchie, programming, 2003-03-07 Dim rng1 As Range, rng2 As Range, bigrange As Range Dim Cell As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual On Error Resume Next Set rng1 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeConstants)) Set rng2 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeFormulas)) On Error GoTo 0 If rng1 Is Nothing Then Set bigrange = rng2 ElseIf rng2 Is Nothing Then Set bigrange = rng1 Else Set bigrange = Union(rng1, rng2) End If If bigrange Is Nothing Then MsgBox "All cells in range are EMPTY" GoTo done End If For Each Cell In bigrange Cell.Formula = LCase(Cell.Formula) Next Cell done: Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On Fri, 10 Dec 2004 17:06:20 -0000, "kez" wrote: I have 7000 addresses in my excel database, approximately 5000 are uppercase text! I need to change them to lower case? is there a quick way without me having to edit them all individually? Thanks "Harald Staff" wrote in message .. . If you have this in cell A1: THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
#10
|
|||
|
|||
Kez
Copy and paste to a general module in your workbook. If not familiar with VBA and macros, see David McRitchie's site for more on "getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm In the meantime.......... To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the above code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. Gord Dibben Excel MVP On Sat, 11 Dec 2004 08:11:26 -0000, "kez" wrote: Hello Gorden I am an absolute beginner to excel , what do I do with this ? Thanks Keith "Gord Dibben" gorddibbATshawDOTca wrote in message .. . Kez Sub Lower_Case() 'David McRitchie, programming, 2003-03-07 Dim rng1 As Range, rng2 As Range, bigrange As Range Dim Cell As Range Application.ScreenUpdating = False Application.Calculation = xlCalculationManual On Error Resume Next Set rng1 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeConstants)) Set rng2 = Intersect(Selection, _ Selection.SpecialCells(xlCellTypeFormulas)) On Error GoTo 0 If rng1 Is Nothing Then Set bigrange = rng2 ElseIf rng2 Is Nothing Then Set bigrange = rng1 Else Set bigrange = Union(rng1, rng2) End If If bigrange Is Nothing Then MsgBox "All cells in range are EMPTY" GoTo done End If For Each Cell In bigrange Cell.Formula = LCase(Cell.Formula) Next Cell done: Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On Fri, 10 Dec 2004 17:06:20 -0000, "kez" wrote: I have 7000 addresses in my excel database, approximately 5000 are uppercase text! I need to change them to lower case? is there a quick way without me having to edit them all individually? Thanks "Harald Staff" wrote in message . .. If you have this in cell A1: THIS IS MY TEXT then enter this in cell B1: =LOWER(A1) and B1 will display this is my text If this is not what you want then please be more specific. HTH. Best wishes Harald "kez" skrev i melding ... Please could you tell me how to do this? Thanks "Harald Staff" wrote in message ... You need a small macro, or a formula in another cell, like =LOWER(A1) HTH. Best wishes Harald "kez" skrev i melding ... How do I format LARGE CASE text to small case in excel 2002. Thanks Keith |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel worksheet in Word linked text boxes | Eduardo Oliveira | Page Layout | 0 | January 5th, 2005 11:23 PM |
Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
Outline | Renee Hendershott | Page Layout | 2 | December 25th, 2004 02:49 PM |
Excel 2003: Need help converting from text to date/time format please | IncomePlanet | Worksheet Functions | 4 | July 29th, 2004 07:35 AM |
Find/Replace text, NOT format!!! | HennyBogan | General Discussion | 5 | June 21st, 2004 08:45 PM |