Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I import text file of cash flow to excel file then use formula
What I want to achieve is to scan in a cash flow (save to PDF) then copy to
an excel spreadsheet and have it recognise the value of the numbers so I can use formulas. The same way you can with word. I have two entitys and I want to add their actual cash flows together to project combined cash folws for future years. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I import text file of cash flow to excel file then use formula
I think this is going to depend on how your scanner software works.
Some will offer a feature to put the results directly into Excel. If your software doesn't, then you could try scanning into a text file or an MSWord file and copy|pasting into excel. In any case, double check those numbers. Scanners don't do perfect OCR. Bumpa wrote: What I want to achieve is to scan in a cash flow (save to PDF) then copy to an excel spreadsheet and have it recognise the value of the numbers so I can use formulas. The same way you can with word. I have two entitys and I want to add their actual cash flows together to project combined cash folws for future years. Thanks. -- Dave Peterson |
#3
|
|||
|
|||
Quote:
you can use trim function to remove spaces, after copying into spreadhseet from pdf. all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to import a text file in excel 2010 | Excel Discussion (Misc queries) | |||
Set Defaults in File Import of a Text File | Excel Worksheet Functions | |||
Develop formula for cash flow | Excel Worksheet Functions | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
Excel cash flow formulas | Excel Worksheet Functions |