Forum Discussion
pdf to excel
hi, is it possible to import a formula that is within a pdf document into Excel to then be able to use that formula for calculations? This is to prevent the transcription of complex formulae into the...
Importing formulas directly from a PDF into Excel doesn't quite work out-of-the-box because Excel treats text from PDFs as plain text. Here's what I do:
- Copy and Paste: First, I copy the formula from the PDF and paste it into an Excel cell.
- Modify the Text: Then, I make sure to add an equals sign (=) at the beginning if it's missing and adjust any cell references or function names.
- Validate: I hit Enter to check if Excel accepts it. If there are errors, Excel will usually give some hints, and I adjust accordingly.
This method requires a bit of tweaking, but it saves time on retyping complex formulas!