How can I get rid of unwanted text/data in a cell?

A

Ant

I have the following entries in a speadsheet from a download. Each row you
see is in one cell. Does anyone know how I can remove all the digits/letters
before 'Payroll general' to leave the cells with 'Payroll general' only? Is
there a formula I can use?

1TM123 Payroll general
1TM285 Payroll general
1TM1235 Payroll general
1TM123 Payroll general
1TM57 Payroll general
1TM12578 Payroll general
1TM1 Payroll general
1TM856 Payroll general
1TM56 Payroll general
 
T

Toppers

Data in A1 ... put formula in B1 (or required column) and copy down.

=TRIM(MID(A1,FIND(" ",A1,1)+1,255))

HTH
 
Top