Extracting multiple strings from a cell

  • Hi,

    I need to figure out how to edit the code at http://www.ozgrid.com/VBA/ExtractNum.htm to separate numbers and strings in a cell. The code referenced grabs all the digits and makes them one number. My intention is to extract digits that are together as a distict number stored in a separate cell, and characters as well. For example, the current code resolves thusly:

    14TB56ATLFINAL resolves as I want 1456. I want 14 in a cell, and 56 in a different cell. Sames goes for TB, ATL and FINAL which should be deleted from all observations. I hope what I am asking makes sense.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!