Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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   Report Post  
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by Bumpa View Post
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.
in case you are able to copy the number from the pdf to excel, make sure there are not spaces in the begining and at the end of the number.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to import a text file in excel 2010 BBailey Excel Discussion (Misc queries) 1 July 21st 09 05:38 PM
Set Defaults in File Import of a Text File Dkline Excel Worksheet Functions 2 January 28th 08 07:20 PM
Develop formula for cash flow sgl Excel Worksheet Functions 3 January 2nd 08 04:46 PM
Would Like to Automate Batch File Creation and Text FIle Import socrtwo Excel Discussion (Misc queries) 2 August 18th 06 03:54 PM
Excel cash flow formulas Kenny S Excel Worksheet Functions 0 January 7th 06 03:49 PM


All times are GMT +1. The time now is 03:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"