Delete the particular data from huge data list

[sampath]

Hi,

I have an huge data in column wise, Every column has "GROUP - *" .

Request is
1. Delete the particular data (GROUP - *).
2. * means more data may come after GROUP - .

Herewith, I have attached the samples. Kindly assist me for the same.

Thank with regards,
Sampath.S

 

[Asheesh]

Go to the tab where you have this data..click CTRL + H and then in Find What section type Group*

then click Replace All Button..

 

[sampath]

Hello Ashessh,

Thanks for your reply. Once using that CTRL + H, that particular Cell only replaced. but I need to remove "GROUP - *" text and after cells from GROUP contained cells.

please check the sample file.

Regards,
Sampath.S

 

[Asheesh]

you must b clicking on remove button....do one thing, instead of clicking on remove button...just press ALT + A..

this should do job

 

[Khalid NGO]

Hi Sampath,

I think you have got solution in your previous thread:
http://chandoo.org/forum/threads/please-assist-me-for-delete-the-particular-data.20410/#post-123617

Correct me if there is any difference?

Regards,

 

[sampath]

Hi Khalid NGO,

I customized that macro for my requirement. but which is not working.

Could you help me for the same.

Herewith, I have attached the samples for the same.

Regards,
Sampath.S

 

[sampath]

Hi Khalid NGO,

Now It's working fine. thanks for your support.

Regards,
Sampath.S

 

[Khalid NGO]

Hi Khalid NGO,

Now It's working fine. thanks for your support.

Regards,
Sampath.S

Hi Sampath,
Glad you solved.


PS. I did't done any thing