+ Reply to Thread
Results 1 to 2 of 2

How to perform find and replace in multiple strings at once??

  1. #1
    Registered User
    Join Date
    04-26-2018
    Location
    India
    MS-Off Ver
    2016
    Posts
    1

    Talking How to perform find and replace in multiple strings at once??

    Hi,

    Can anybody explain me how to perform a find and replace in multiple strings. There are multiple lines where i need to add html tags at the start and end by performing a find and replace.
    For example: There are lines like:
    "What is Ecosprin 75 mg Tablet?" and "Common Side Effects of Ecosprin 75 mg Tablet:".
    These are few sample lines that where i want to make the changes "What is ...........?" and "Common Side Effects of .........:". These parts are common in the string. I just need to replace this with something like this.

    The replacements would be : </p><p><b>What is Ecosprin 75 mg Tablet?</b></p><p><br> & </p><p><b>Common Side Effects of Ecosprin 75 mg Tablet</b></p><p><br>

    There are similar lines in the content. Multiple find and replace needs to be done to achieve it. It can be achieved through Macros only. I tried doing it, can anybody help me with it.Can anybody help me with this???
    Last edited by ASHIS1994; 04-26-2018 at 09:07 AM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,645

    Re: How to perform find and replace in multiple strings at once??

    As you said, it can be achieved through macros only.

    In Excel you have to do an individual find & replace for each string you want to replace. Microsoft Word has more sophisticated pattern match and replace capabilities that could do what you want, but Excel does not have this.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Moved to commercial services forum.
    By Midnight-Oil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-28-2015, 01:05 PM
  2. Macro to Perform Find and Replace Function Please HELP!
    By Elizabethd1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-08-2014, 07:13 PM
  3. Perform Find-and-replace on clipboard before pasting
    By adykhu55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-17-2014, 05:52 PM
  4. Find and Replace for longer strings?
    By flipjarg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2012, 09:28 PM
  5. Multiple Find and Replace to replace a list of strings
    By WalterP34 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-11-2011, 07:41 PM
  6. find and replace - text strings
    By yabai1974 in forum Excel General
    Replies: 6
    Last Post: 08-01-2007, 08:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1