Results 1 to 8 of 8

Do Find & Replace multiple times using data in Col B for find & data in Col C for replace

Threaded View

ILoveStMartin Do Find & Replace multiple... 10-27-2012, 01:42 AM
mrice Re: Do Find & Replace... 10-27-2012, 10:23 AM
ILoveStMartin Re: Do Find & Replace... 10-28-2012, 01:13 PM
mrice Re: Do Find & Replace... 10-28-2012, 03:37 PM
ILoveStMartin Re: Do Find & Replace... 10-28-2012, 11:18 PM
event21 Re: Do Find & Replace... 10-29-2012, 12:58 AM
ILoveStMartin Re: Do Find & Replace... 10-29-2012, 07:45 AM
event21 Re: Do Find & Replace... 10-29-2012, 08:23 AM
  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Do Find & Replace multiple times using data in Col B for find & data in Col C for replace

    In column A I have over 250 pieces of data - odd data in that it is separated into 4 parts because there a 3 periods in each piece of data.
    In columns B & C I have about 90 rows of Find this Data (Column B) and equal number of rows of "change to" data in column C
    I want all 4 parts to contain 3 digits
    For example in B I have find .0. and in C1 I have .000. as the data to replace .0.
    Want the macro to run and run until ever possibility in Column B has been checkid out.
    Is this do one thing after another - row after row called a loop?
    Thanks
    Last edited by ILoveStMartin; 10-27-2012 at 08:56 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