In the last couple of weeks, I was searching for some evidence in the literature related to resource usage in telemonitoring. And part of this job consisted on copy pasting table from PDF(I recommend using Foxit reader instead of Adobe reader ) to word. And believe me it’s not that as easy as you might think. In some cases, MS word can do most the work by converting the text into a table ( option 1), but in some cases the formatting of the original data is so distorted that even word cannot sort it. That why, I have written the following VBA code (option 2) to be added to excel (It could be useful in certain circumstances, and easily tweaked according to the original data).
Function TestingRev(inputStr As String) As StringDim nbCol As IntegernbCol = 4Dim revInputStr As StringrevInputStr = StrReverse(inputStr)Dim ret As Stringret = Replace(revInputStr, " ", ";", 1, nbCol - 1)TestingRev = StrReverse(ret)End Function