Find and Replace that contains some word

P

proton

Hello,
I would like to find and replace data in some column. Lets say in
column C.
But i have some problem....
The data in this column which i have to pepcace may contain some
aditional texts
For example :
I would like to replace .ACD with .ABC
in come cells .ACD have aditional texts .ADC Bookmark For You.
Is it possible to replace whole cell which Begins with .ADC with
..ABC??

I wrote this script but it doesnot work

Sub Replace()

Range("C").Replace What:=".ACD '*', Replacement:=".ABC"
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top