Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
Hi there
I have a file with names and adresses in different colums. They HAVE different formats LIKE this...is it possible to tranform all text to BLOCKLETTERS for example? Fred |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
Right click on sheet tab, view code.
Paste this in, and run: Sub UpperCase() For Each c In Me.UsedRange c.Formula = UCase(c.Formula) Next End Sub -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Fred Asp" wrote: Hi there I have a file with names and adresses in different colums. They HAVE different formats LIKE this...is it possible to tranform all text to BLOCKLETTERS for example? Fred |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
=UPPER(A1)
-- David Biddulph "Fred Asp" wrote in message ... Hi there I have a file with names and adresses in different colums. They HAVE different formats LIKE this...is it possible to tranform all text to BLOCKLETTERS for example? Fred |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
Try this small macro:
Sub capitallize() For Each r In ActiveSheet.UsedRange r.Value = UCase(r.Value) Next End Sub Macros are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To use the macro from the normal Excel window: 1. ALT-F8 2. Select the macro 3. Touch Run To remove the macro: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu200859 "Fred Asp" wrote: Hi there I have a file with names and adresses in different colums. They HAVE different formats LIKE this...is it possible to tranform all text to BLOCKLETTERS for example? Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |