Upper-case for the Second Character

**longbow007** · 09-20-2009, 07:27 PM

Hello, could some one please help with the following:

In column J of my Excel 2003 worksheet named: Sheet1, is a list of mailing addresses.

A copy of the spreadsheet is attached.

I need a macro to please capitalise (Upper-case) the second character only of all the Post Office addresses.

Example:

Po Box 65, ORLANDO, NSW 2697

All of my Post Office addresses are prefixed: Po

I need the Post Office addresses to be prefixed: PO

So, the above mentioned example should look like this: PO Box 65, ORLANDO, NSW 2697

If any one could please help - that would be much appreciated.

Kind regards,

Chris

**shg** · 09-20-2009, 07:29 PM

Why not just find and replace "Po " with "PO "?

**longbow007** · 09-20-2009, 08:00 PM

Hi shg, thanks for your enquiry. My list of addresses is usually 10,000 or more rows. The user of the spreadsheet has absolutely no computer skills what so ever. To make life easier, I am trying to automate this process.

Kind regards,

Chris

**Leith Ross** · 09-20-2009, 10:12 PM

Hello Chris,

This macro will correct the "PO" portion of the address. It has been added to the attached workbook.

Please Login or Register  to view this content.

To Run the Macro...
To run the macro from Excel, open the workbook, and press ALT+F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.