Excel Query!

I have a excel query: I have the following type of text in hundreds of rows: 03 Mar 2010 09:49:00 GMT+05:30 I have to delete GMT+05:30 from each row in that cell What is the easy way for doing this? I can do it by applying a formula in excel but it is of no use to me as it takes the reference of the old cell. Can it be done in any way in excel 2007?

Not that i know of. I guess 2003 and 2007 are not that change as far facilities are concerned. But if anybody knows any hint to do that, i would be interested to learn as i am an EXCEL learner as well.

It's going to really depend on how that information got in the cell in the first place. It could be as simple as reformatting the cells.

Hey, It is resolved. It is very simple. 03 Mar 2010 09:49:00 GMT+05:30 Press Ctrl+F and select Replace tab. Now, type GMT+05:30 in Find What field and leave Replace with Field. Now, click on Replace All button and done!!!

From search option find all and delete. And second method is that replace all this name by blank space.