Remove numbers from text cells
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
|