Hi All

Hope someone out therecan help put me on the right track to solving this problem.

I have multiple cells which all have various amounts of data in them, the core part of the data is always in the same format but the string length of the data can vary from cell to cell. I need to be able to use each segment as a reference for a Vlookup which will ultmately sum up all the results of the individual lookups.

Cell format is

A1 DP 001DP 002 DP 003DP 004
A2 DP 125DP 235 DP 555DP 652DP 555DP 012
ETC

The data I need to extract and perform lookup with is DP xxx, so I want to look at a section of the cell which is always 6 characters long .

The cells are in a column and each cell is of a varying legth but always in multiples of 6. I am able tp extract the information by just using a simple left/right character formula but this is a very manual process and I have a grid of 90*90 cells that i need to work on.


Hope someone can help

M