3 Replies Latest reply: Jun 29, 2013 7:27 AM by Stefan Wühl RSS

    Extract number from text field

    Bradley Coyne

      hi in the following excel applikation i wish to extract only the last four numbers off each row.

      if a row is lacking the four numbers (companycode) i wish not to read them.

       

      i have tried trim function without luck as each of the rows have different lengths;

       

      any suggestions?

       

       

      Best,

      Brad