4 replies to this topic

[vijay.gupta]

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?

[MobileMania]

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.

[Tomk]

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.

[vijay.gupta]

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!!!

[JohnRocks]

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