Why put into Excel only to import into Access later - probably as un-normalized data?
I didn't know that was an option, but after reading this post, results from attempts to dump the data from the PDF into Access were decidedly worse than the output in Excel. I do appreciate the suggestion though!
I did manage to figure out a way to do this, but it ended up being a program written in AutoHotkey rather than a formula in Excel or Access. I know this is an Access forum, but I figure someone might stumble on this someday, so I thought I would post the base code. I just activate the top cell and it copies the last character onto the clipboard, checks to see if it is "-", if it is, it deletes it and adds it to the front of the data and then does it again on the cell below, and if not moves on to the next cell.
Thanks!
Code:
+F12::
Loop, 500
{
clipboard := ""
SendInput, {F2}
SendInput, +{Left}
SendInput, ^c
Clipwait
clip1 = %clipboard%
text = -
If InStr(clip1, text)
{
SendInput, {Backspace}
SendInput, ^{Left}
SendInput, -
SendInput, {Enter}
}
Else
{
SendInput, {Right}
SendInput, {Enter}
}
}