2016年9月10日 星期六

Sold record and Hot stock list convert to Excel for analysis

A) how to convert hot stock.pdf to excel for analysis

1. firstly, convert hot stock to PDFelement as Word format.docx

2. Secondly, convert this Word format.docx to Excel format.xlsx by upload to Watermark-Image.

3. Download from Watermark-Image and edit in Microsoft Excel.

4. Use SearchB function: F3 =SearchB("(", E3, 1)

5. Use MidB funtion: =MidB(E3,2, F3-1)

Besides, PDF element have iPhone App


B) Monthly sold record.pdf

1. Use Cometdocs to convert Monthly sold record.pdf to Word format.docx

2. Use Watermark-Image to convert Word format.docx to Excel



C) Whole Building sold record.pdf

1. Use EasyPDFClound (or EasyPDF iPhone App) to convert .pdf to Excel format directly.

沒有留言: