Hi Imogen,

Am Tue, 15 Dec 2015 23:16:49 -0800 (PST) schrieb imogen b:

12/08/15
Company A
$10
12/11/15
Company B
$20
12/14/15
Company C
$30

Instead of like this (in three columns):

12/08/15 Company A $10
12/11/15 Company B $20
12/14/15 Company C $30

look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "PDFtoExcel" and download the file because macros are disabled in
OneDrive.
In the workbook are two suggestions. One with VBA and one with formula.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional