I have a PDF document that I'm exporting into excel that comes all messed up. I can fix most of the problems with formulas and VBA, but there's one I just can't seem to fix. I'll paste it at the end of this message, but explain it a little more first. It exports with a number, then a lot of spaces, and then my text. All I need is the text. I tried using the TRIM and Substitute formulas and it didn't work. I also tried the RIGHT formula, pasting as values, and then using Trim, but it doesn't work either. Any ideas?
Solved by A. H. in 22 mins