software

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 generalData in A1 ... put formula in B1 (or required column) and copy down.

=TRIM(MID(A1,FIND(quot; quot;,A1,1) 1,255))

HTH

quot;Antquot; wrote:

gt; I have the following entries in a speadsheet from a download. Each row you
gt; see is in one cell. Does anyone know how I can remove all the digits/letters
gt; before 'Payroll general' to leave the cells with 'Payroll general' only? Is
gt; there a formula I can use?
gt;
gt; 1TM123 Payroll general
gt; 1TM285 Payroll general
gt; 1TM1235 Payroll general
gt; 1TM123 Payroll general
gt; 1TM57 Payroll general
gt; 1TM12578 Payroll general
gt; 1TM1 Payroll general
gt; 1TM856 Payroll general
gt; 1TM56 Payroll general
gt;

Thank you - that's perfect

quot;Toppersquot; wrote:

gt; Data in A1 ... put formula in B1 (or required column) and copy down.
gt;
gt; =TRIM(MID(A1,FIND(quot; quot;,A1,1) 1,255))
gt;
gt; HTH
gt;
gt; quot;Antquot; wrote:
gt;
gt; gt; I have the following entries in a speadsheet from a download. Each row you
gt; gt; see is in one cell. Does anyone know how I can remove all the digits/letters
gt; gt; before 'Payroll general' to leave the cells with 'Payroll general' only? Is
gt; gt; there a formula I can use?
gt; gt;
gt; gt; 1TM123 Payroll general
gt; gt; 1TM285 Payroll general
gt; gt; 1TM1235 Payroll general
gt; gt; 1TM123 Payroll general
gt; gt; 1TM57 Payroll general
gt; gt; 1TM12578 Payroll general
gt; gt; 1TM1 Payroll general
gt; gt; 1TM856 Payroll general
gt; gt; 1TM56 Payroll general
gt; gt;