Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    113

    Unanswered: macro to find and replace

    hey guys,
    what code do i write up find and replace data in a certain collumn?
    I am trying to change "los angeles" to "so cal" and blanks to "so cal"

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Check out this thread where at least seven different methods are presented, some very detailed. I have opted for the Dictionary Object Model (many uses, speed, and daily use)

    Find and Replace VBA Options
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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