Remove numbers from text cells

[Jay07]

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 thank

 

[Claus Busch]

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,COLUMN(1:1))*1))+1,99),"-",))

Regards
Claus Busch

 

[lhkittle]

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

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