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?