Remove\Replace the data in the table

[pavanthota]

Hi,

I have the data below like this

Sample:

A   B  C

a,b(sample),c k3

n(sample),m k3(sample),b

v k3(sample), x s2, y

;

I want to find (sample), k3(sample),s2 and k3 these strings in entire table irrespective of colums replace with null or remove the data in the table.

Could you please help me anyone  to find out the answer

Thanks,

Pavan

[#2]

Hi ,

I think you need to use replace() function for each individual column..

Please find the attached Application..

Hope it gives you some insight!!!

Thanks

Bhaskar