Hi
This is driving me mad.. altho in fairness I am somewhat dopey
I need a macro that outputs the result in a new cell when a paragraph is pasted into A1 .. the macro needs to do a multiple find and replace on a paragraph of text in a cell.
it needs to replace words on the left with words on the right in a text paragraph of about 80 words
exit - leave
approximately - around
past - after
continue - carry on
hit - reach
I have 500 diffferent paragraphs to do this on one by one as they are pulled from one page and then changed and pasted onto another.. so the fewer mouse clicks needed the better.
Thanks if you can help... going bald here..
This is driving me mad.. altho in fairness I am somewhat dopey
I need a macro that outputs the result in a new cell when a paragraph is pasted into A1 .. the macro needs to do a multiple find and replace on a paragraph of text in a cell.
it needs to replace words on the left with words on the right in a text paragraph of about 80 words
exit - leave
approximately - around
past - after
continue - carry on
hit - reach
I have 500 diffferent paragraphs to do this on one by one as they are pulled from one page and then changed and pasted onto another.. so the fewer mouse clicks needed the better.
Thanks if you can help... going bald here..