Hi All,
I am sent a pdf copy of an excel report that i would like to re-generate in to an excel file. (can't get the original sent to me for many reasons).
Previously, I've done a highlight, copy, paste in to Excel, then had to convert 'text to columns' and all is simple and fine.
Problem now is instead of the text in the rows being in one cell (to text to column convert) it is just pasting each column down the row so can not convert to columns.
Is there something i can do to get this to work for me to text to column convert?
I am sent a pdf copy of an excel report that i would like to re-generate in to an excel file. (can't get the original sent to me for many reasons).
Previously, I've done a highlight, copy, paste in to Excel, then had to convert 'text to columns' and all is simple and fine.
Problem now is instead of the text in the rows being in one cell (to text to column convert) it is just pasting each column down the row so can not convert to columns.
Is there something i can do to get this to work for me to text to column convert?
