Hi Jay,

Am Wed, 22 Aug 2012 10:34:11 +0000 schrieb Jay07:

71047 - INSPECT CHIMNEY
71334 INTERNAL ALTERATION AS RFQ3369
72107 - CLASSROOM EXTENSION
90082 WORKS TO MAIN PLAYGROUND

I don't need the numbers and want the cells to just read

INSPECT CHIMNEY
INTERNAL ALTERATION AS RFQ3369
CLASSROOM EXTENSION
WORKS TO MAIN PLAYGROUND

your text in A1 then:
=TRIM(SUBSTITUTE(MID(A1,LEN(LOOKUP(9^9,LEFT(A1,COL UMN(1:1))*1))+1,99),"-",))

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2