Results 1 to 4 of 4

Customer name changed to Proper case with exception

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2009
    Location
    Sydney
    MS-Off Ver
    Excel 2003
    Posts
    2

    Smile Customer name changed to Proper case with exception

    Hi,

    I have a column with supplier Names. I need to make sure that all names are in Proper case. I can run Proper formula but it will change everything. I have exception name like ABC Castings Pty Ltd which need to stay as it is and do not want to turn in Abc Castings Pty Ltd.

    Does anyone know what will be work around and how it can be durable?

    I have attached one part of the spreadsheet.

    Please note I have 30,000 lines to change.

    Thanks in advance,
    -Krs
    Attached Files Attached Files
    Last edited by krs179; 04-17-2009 at 01:19 AM. Reason: Title change

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