Excel Worksheet Tips: PDF Table to Excel – UPDATE On occasion I need to pull in a table of data from a PDF file into an excel spreadsheet to manipulate the data or to add to it. However, highlighting the table in the PDF, copying and then trying to import into excel doesn’t work. It…
Read More
Excel Worksheet Tips: Table from PDF to Excel At work today, I was asked if there was a way to extract the data from a table in a PDF in Adobe Reader and paste it into an excel workbook. You can, if you have the expensive adobe acrobat version; however, for the rest of us,…
Read More
Excel Worksheet Tips: convert numbers to text and text to numbers I use excel on a daily basis and as I come across things that I have needed to look up, I will post them here. The first thing I have come across is converting numbers stored as text into actual numbers and vice versa.…
Read More
