Hello all,

I am very new (never written a macro)!

I have a MS Word Doc that I get external data form text (Data Ribbon). Then i fix certain colums for the display one issue is taht alot of special characters are there, but i can live with it for now.

Example: Data in the column is whacky (becasue of special chars.), but I have some values in there in which I can filter on. What I did was create "contains" filter for <Contains *.% Panel*>, then I get lots of rows (I tried to create custom filter and add (<Contains *.% Panel*> and <Contains *.% Fed From*>) but the data came back really funky)...below is the data only using the Contains filter for Panel.

.% Panel :bbbbbb
.% Panel :bbbbba
.% Panel :bbbbbc
.% Panel :bbbbbe
.% Panel :bbbbbf

Now I want to trunacte this to only anything after the colon (There may be whitespaces after the colon though). Then I want to copy thise to another sheet. Can I do all this writing some codes, so idont always have to manually do all of this?

Hope this is clear!
Thanks in advance,
Niraj