I regularly receive a PDF which I can convert to an eXcel document but the format is not one amenable to the tasks I perform next for my golf buddies. I know that the formula experts here can easily solve this dilemma from the attached - the input is in the left 3 columns, the usable (desired) output is in the right 3.
Your help will be really appreciated!

Attached Files

Challenge1.xlsx (9.5 KB, 8 views)

Does this help?

Attached Files

Challenge1.xlsx (10.2 KB, 10 views)

Thank you very much for your time and effort! Much appreciated.

I now receive a simple PDF which I convert to eXcel with a number, an <alt>CR, a bullet and a name - I only need the name. A short example is attached with the extraction done manually. A Formula to get everything after the bullet would be a true blessing!

Attached Files

Challenge2.xlsx (10.0 KB, 8 views)

Look at column H in the file ArviLaanemets supplied for you.

By Golly, it works - Thanks a bunch!