Deleting part of a cell

[jaybeen]

Hello,

I want to delete part of a cell in Excel. For example if a cell had the data "BlueGreen" how would I delete the "Blue" bit just to leave the "Green" bit behind? Surely there is an easier way then physically deleting the first part in each cell??? I have about 4000 cells to work on!!
Please help and regards,
Jaybeen.

 

[tape deck]

Both formulas worked beautifully. Thank you very much, klb and Boller. I swear, I would pay by the hour for the advice of this board. One week's work now eqauls one hour's work.

 

[klb]

You're welcome.
You pay it back when you are able to answer a question for someone else. Plus it is amazing what you can learn helping others.