View Single Post
  #1   Report Post  
Jay07 Jay07 is offline
Member
 
Location: Birmingham
Posts: 35
Default 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