+ Reply to Thread
Results 1 to 5 of 5

three-word keyword from column a and replace it in all instances in column b problem

  1. 12-16-2013, 06:11 PM #1
    DukeURL
    DukeURL is offline
    Registered User
    Join Date
    12-16-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Question three-word keyword from column a and replace it in all instances in column b problem

    Hello, I need to take a three-word keyword from column a and replace it in all instances in the adjacent row in column b. And, I need to do that for 10,000 + rows. I am using Excel 2010. Any help is greatly appreciate!

    Column A = really cool widget

    Column B = Buy {A} online here! You will love your new {A}.

    Column C = Buy really cool widget online here! You will love your new really cool widget.


    Thanks!

    DukeURL
    Reply With QuoteRegister To Reply
  2. 12-16-2013, 06:20 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: three-word keyword from column a and replace it in all instances in column b problem

    Try:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 12-16-2013, 06:20 PM #3
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: three-word keyword from column a and replace it in all instances in column b problem

    C1 =substitute(b1,"{a}",a1)
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!
    Reply With QuoteRegister To Reply
  4. 12-16-2013, 06:24 PM #4
    DukeURL
    DukeURL is offline
    Registered User
    Join Date
    12-16-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: three-word keyword from column a and replace it in all instances in column b problem

    Wow, thank you very much for your help. I have been struggling with this problem for four hours. And, I receive such great responses within mere minutes. I love ExcelForum.com!
    Reply With QuoteRegister To Reply
  5. 12-16-2013, 06:29 PM #5
    daffodil11
    daffodil11 is offline
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: three-word keyword from column a and replace it in all instances in column b problem

    Thanks for the feedback, glad we could help out.

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count instances of a word with column across multiple sheets
    By JohnDeere in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-13-2013, 12:06 PM
  2. Find a keyword and replace with list of values from a column
    By georgemathew46 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2013, 10:34 AM
  3. Filter List by Keyword & copy the result in column by keyword as header
    By kitunga in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2013, 07:16 AM
  4. Excel 2007 : How to replace specific word in column B with words from column A?
    By emil9216 in forum Excel General
    Replies: 2
    Last Post: 04-29-2011, 10:53 AM
  5. is it possible to count instances of a word in a column?
    By alexfleming in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-14-2009, 04:24 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1