Results 1 to 5 of 5

Upper-case for the Second Character

Threaded View

longbow007 Upper-case for the Second... 09-20-2009, 07:27 PM
shg Re: Upper-case for the Second... 09-20-2009, 07:29 PM
longbow007 Re: Upper-case for the Second... 09-20-2009, 08:00 PM
Leith Ross Re: Upper-case for the Second... 09-20-2009, 10:12 PM
longbow007 Re: Upper-case for the Second... 09-21-2009, 12:51 AM
  1. #1
    Forum Contributor
    Join Date
    06-13-2009
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    245

    Upper-case for the Second Character

    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
    Attached Files Attached Files
    Last edited by longbow007; 09-21-2009 at 12:52 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1