Hello,

We have an excel output from a PDF file, however this get's data spread out over multiple columns ( 4 at max) based on the amount of spaces in the field ( because each space followed by a word creates a new column in the overview).

In this string of field I would like to look for a specific range of 100+ values that are each unique in order to filter out which type is which so that I can use these for further Macro Purposes.

Is there anybody who can help me with this, without having to manually delete fields in order to get the structure?

If you have any questions please let me know?