On Wednesday, August 22, 2012 3:34:11 AM UTC-7, Jay07 wrote:
Hi all,



Does anyone know how to do this?



Example of data...



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





Many thanks









--

Jay07

I believe I got there using Find - (dash) and Replace All w/nothing.
Then...

=MID(G4,FIND(" ",G4+1,LEN(G4)-FIND(" ",G4)))

Adjust range to suit, and you may want to do a COPY - PASTE SPECIAL - VALUES to get rid of the formulas.

Hope yhat helps.

Regards,
Howard