+ Reply to Thread
Results 1 to 10 of 10

Using Replace() to search for a two-word phrase

  1. 06-09-2015, 01:21 PM #1
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Using Replace() to search for a two-word phrase

    When I run the following against a single word, it runs fine, but I need to run it against a two-word phrase. I'm getting a bug when I try. 

    Please Login or Register  to view this content.
    Any ideas on how I might account for the space in the search string?
    Reply With QuoteRegister To Reply
  2. 06-09-2015, 01:25 PM #2
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Using Replace() to search for a two-word phrase

    can you provide the workbook to better understand and test?
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  3. 06-09-2015, 01:34 PM #3
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Re: Using Replace() to search for a two-word phrase

    Sure - See attached.

    It's the B_ReplaceHeaders macro...
    Attached Files Attached Files
    Last edited by jpcsolutions; 06-09-2015 at 01:35 PM. Reason: Added macro title
    Reply With QuoteRegister To Reply
  4. 06-09-2015, 01:40 PM #4
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Using Replace() to search for a two-word phrase

    It is not clear to me what you are trying to accomplish. Are you just trying to change cell A1 so that instead of "Last Name" is says "LAST_NAME"?

    If so, then this will do that

    Please Login or Register  to view this content.
    Last edited by stnkynts; 06-09-2015 at 01:44 PM.
    Reply With QuoteRegister To Reply
  5. 06-09-2015, 01:45 PM #5
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Re: Using Replace() to search for a two-word phrase

    Yes - That's exactly what I'm trying to do. I have other 'Replace()' functions running in the same Workbook, and they run fine when running a single term - like this... 

    Please Login or Register  to view this content.
    It works fine...
    Reply With QuoteRegister To Reply
  6. 06-09-2015, 01:58 PM #6
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Re: Using Replace() to search for a two-word phrase

    Did you try what you suggested? It's not working for me?

    Can you show me the full block? Or was it only that line you replaced?
    Reply With QuoteRegister To Reply
  7. 06-09-2015, 02:11 PM #7
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Re: Using Replace() to search for a two-word phrase

    When I add the line you suggested, this is what my block looks like... 

    Please Login or Register  to view this content.
    Is there something I'm missing?
    Reply With QuoteRegister To Reply
  8. 06-09-2015, 02:16 PM #8
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Re: Using Replace() to search for a two-word phrase

    Nevermind. I've figured it out. I removed everything else and just used what you suggested. It was simply to cluttered with code. Thanks for your help!
    Reply With QuoteRegister To Reply
  9. 06-09-2015, 02:17 PM #9
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Using Replace() to search for a two-word phrase

    Is there something I'm missing?
    Yes. Your last lines are referencing the wrong variable. It should instead be:
    Please Login or Register  to view this content.

    With that being said, you should only need these 2 lines (tested and worked).

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 06-09-2015, 02:25 PM #10
    jpcsolutions
    jpcsolutions is offline
    Registered User
    Join Date
    08-11-2011
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2007/ 2010
    Posts
    72

    Re: Using Replace() to search for a two-word phrase

    Thanks for the reply. I've added to your rep. Much appreciated!
    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. Search by word and replace with date
    By devpp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2015, 05:29 AM
  2. [SOLVED] Search using a Word/Phrase
    By hiteshasrani43 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-05-2015, 01:02 AM
  3. [SOLVED] Search column of cells for a phrase, then change a cell to match a parallel cell to phrase
    By airhoodz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2014, 05:14 AM
  4. Search and Replace... from Excel to Word
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2011, 03:05 PM
  5. [SOLVED] Newbie trying to search and replace word in word doc from excel
    By kaiser in forum Excel General
    Replies: 5
    Last Post: 09-13-2005, 07:06 AM

Tags for this Thread

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