On Sun, 21 Aug 2005 19:39:36 +0100, "N E Body"
wrote:

Hi everyone

I need to split data. A cell contains CHH05 and I need a formula that will
give a result of CHH.

Could someone suggest a solution?

TIA

Kenny
Win NT and 2000 with Office 97


=LEFT(cell_ref,3)


--ron