Find and Replace Exact Word in Sentence.

**rr1050** · 10-02-2014, 03:23 PM

Hello Friends,

Weekend starts,you may find time to solve thread.

Attach File

L Column Find word
M Column Replace Word
N Sentence

My requirement looping for replace the word in N column. That means, by refering the L &/OR M last rows replace word in sentence by looping ie. L2 ....M2 to last row. Replacemet should if whole word match found then only. example Home replace with House; but if word Homealone then no changes.

Yellow shaded will be result (in attach file).

Have a nice weekend...
Thanks Regards, RL

**Richard Buttrey** · 10-02-2014, 04:38 PM

Hi,

Try the following UDF

In O2 enter

Formula:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**Olly** · 10-02-2014, 04:47 PM

Try:

Please Login or Register  to view this content.

Permissible trailing character after the search string (e.g. space, full stop) are defined in the s array. So if, for example, you DO want to replace "home," with "house,", then change that line to:

Please Login or Register  to view this content.

**rr1050** · 10-03-2014, 01:58 AM

Both methods given exact result which requires my thread (question).

Many thanks

Thanks your valuable time.

Find and Replace Exact Word in Sentence.

LinkBack

Thread Tools

Rate This Thread

Display

Find and Replace Exact Word in Sentence.

Re: Find and Replace Exact Word in Sentence.

Re: Find and Replace Exact Word in Sentence.

Re: Find and Replace Exact Word in Sentence.

Thread Information

Users Browsing this Thread

Similar Threads

Find and replace a new sentence or paragraph in word doc

to find a word in a sentence in acell

Replace word in a sentence

Find word in sentence

How to find and replace a word in a sentence with VBA

Bookmarks

Bookmarks

Posting Permissions