+ Reply to Thread
Results 1 to 2 of 2

find and replace multiple values

  1. #1
    Registered User
    Join Date
    06-08-2006
    Posts
    12

    find and replace multiple values

    is there any way in excel or any other application that

    i want a method that find a value in colume A then replace all the duplicate values in colume B.

    its simple find and replace method but i want to replace multiple values at the same time .
    e-i i dont want to write find and replace values every time.
    just in one go it change all the values

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    Sub caps()
    Worksheets("Sheet1").Columns("A").Replace _
    What:="england", Replacement:="England", _
    SearchOrder:=xlByColumns, MatchCase:=True
    End Sub
    Best regards,

    Ray

+ Reply to Thread

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