Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using PROPER function
Dear all,
I have a Excel sheet with 13,000 names and address that are all i upper case. Is there way to automate the Proper function so that th cases are corrected? That is, the first character of the first an last names is in upper case and rest in lower case. I'm rather new t using macros in Excel. Thanks in advance! -Chri -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using PROPER function
Hi
see: http://www.mvps.org/dmcritchie/excel/proper.htm -- Regards Frank Kabel Frankfurt, Germany Dear all, I have a Excel sheet with 13,000 names and address that are all in upper case. Is there way to automate the Proper function so that the cases are corrected? That is, the first character of the first and last names is in upper case and rest in lower case. I'm rather new to using macros in Excel. Thanks in advance! -Chris --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using PROPER function
This sounds like a one time job.
Do not use a macro. Assuming Names and Addresses are in columns A & B Insert two columns at C In the new C =Proper(A1) In the new D =Proper(B1) Select C1:D1, Copy Down. Select C:D, Copy, Paste Special Values. Inspect and edit. Delete Columns A:B Stephen Rasey Houston http://wiserways.com http://excelsig.org "CLew " wrote in message ... Dear all, I have a Excel sheet with 13,000 names and address that are all in upper case. Is there way to automate the Proper function so that the cases are corrected? That is, the first character of the first and last names is in upper case and rest in lower case. I'm rather new to using macros in Excel. Thanks in advance! -Chris --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using PROPER function
Chris,
Here is some simple code Dim cell As Range For Each cell In Selection cell.Value = WorksheetFunction.Proper(cell.Value) Next cell -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CLew " wrote in message ... Dear all, I have a Excel sheet with 13,000 names and address that are all in upper case. Is there way to automate the Proper function so that the cases are corrected? That is, the first character of the first and last names is in upper case and rest in lower case. I'm rather new to using macros in Excel. Thanks in advance! -Chris --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro using PROPER function
Thanks to all of you for the suggestions. I followed Stephen's advic
regarding pasting special values into new columns since it seemed th easiest. But I'll definately keep all of it on record for the nex time I get set of lists from the distributor! All the best, Chri -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Proper function | Excel Worksheet Functions | |||
Insert "Proper Function" into existing macro | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Discussion (Misc queries) |