Split column, at odd location

[brando600333]

Hello,

I ran a pdf conversion to a spreadsheet and the conversion is not splitting the column, so digits are running into each other, AG12 is one of the locations where this is happening. Power Query is where I would usually do this split but I'm hoping to build a macro to convert this pdf conversion into a sheet like you see on sheet 2 of the attached, so sometimes it will be 5 characters, sometimes 6 etc. Thanks for the ideas.

Cheers!

[thenewkidd]

Are you merging the cells or is excel doing this after importing the PDF file?
is Table1 tab completely undoctored and exactly how it looks on import?

I have an "hours worked" document I import that is not very "excel friendly" and was able to parse out spaces and specific markers so that I could generate how many hours an employee worked in a given work center for a month.
It was basically a "word doc" converted into an excel workbook and the macro works but it works because it behaves the same way every time it is imported.
The number of characters aren't important as so much what characters are always available (there is always a space, and we need to find out what type of space is being imported, char(32) or char(160).. it sounds dumb but one can be trimmed the other cannot. and we will have to account for that.

[TMS]

In cell AG12 it is a space, CHAR(32).

[brando600333]

Hi TMS,

Crap, I think I tinkered with it and forgot to put it back, I wish there was a space, but I'm not that lucky.

I reuploaded the file.

Thanks for the help!

Kind regards,
Brandon

[brando600333]

Hi New Kidd,

Yeah, its merging those cells. I'm using adobe, but I've tried a few others and the merging gets nuts, for example the whole block of hours is just a single merge.

Unfortunately, I'm getting some variability in the export, but I'll figure out a way to manage that; I have some ideas.

And I reuploaded the file, there isn't a space in the original file, I had been tinkering with it and forgot to put it back.

Thanks for any ideas you might have.

Kind regards,
Brandon