• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

txshadow will think other title for this


New Member
Hi All!

First off, let me preface this by saying - I AM NOT AN EXPERT AT ALL! I find most of my answers through the internet, so please show some grace.

I am in-porting a huge list of data from a pdf with multiple pages into excel with different categories. I have extracted 99% of it but now am running into my final issue.
I need to grab first and last names from this source (pg) and this page is very inconsistent. The characters, spaces and values are all different (a user input error that wont be fixed anytime soon).
HOW CAN I EXTRACT THEIR NAMES WITH INCONSISTENT DATA??? Is there even a way?? I tried playing with VBA (which I know very little about) and found a script but it obviously didn't work.

I can isolate the are of where the names are found (between 2 constants) - but that leaves me with an inconsistent cell filled with random/different characters/values and the names buried in there.


Thanks in advance!


  • 2024-04-23_16-10-09.png
    18.1 KB · Views: 7
Cannot manipulate data in a picture. Upload a sample file that is representative of your issue and we will do our best to provide you with a workable solution.

BTW: You will always get more responses with a descriptive title to your thread. Titles such as your often get ignored