I have created the follwoing based on different formulas from other posts.
There is a list of contact details I have scanned into Word then validated and copied into Excel. There are names, addresses, tel nos and other info. Unfortuately not all are complete so its a bit of a dogs breakfast.
I am trying to get them as uniform as possible so that I can then transfer them into Access and start to create a porper contact database.
In the Excel stage all appears to work OK for the first set of records but then produces the #N/A error. Can anyone please help guide me as to what I am doing wrong.
Bernard
There is a list of contact details I have scanned into Word then validated and copied into Excel. There are names, addresses, tel nos and other info. Unfortuately not all are complete so its a bit of a dogs breakfast.
I am trying to get them as uniform as possible so that I can then transfer them into Access and start to create a porper contact database.
In the Excel stage all appears to work OK for the first set of records but then produces the #N/A error. Can anyone please help guide me as to what I am doing wrong.
Bernard
From Word Xerox Draft2.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Data | 1 | Trans | Record | fldOrganisation | fld2 | ||
2 | CareDirectGloucestershire | 1 | 1 | CareDirectGloucestershire | Freepost | |||
3 | Freepost | 1 | 2 | #N/A | #N/A | |||
4 | SWC4572 | 1 | 3 | #N/A | #N/A | |||
5 | GLoucester | 1 | 4 | #N/A | #N/A | |||
6 | GL12ZZ | 1 | 5 | |||||
7 | Bus:0800444000 | 1 | 6 | #N/A | ||||
8 | BusinessFax:01452427359 | 1 | 7 | #N/A | #N/A | |||
9 | E-mail:caredirect@gloscc.gov.uk | 1 | 8 | #N/A | #N/A | |||
10 | 9 | #N/A | #N/A | |||||
11 | CaringConnectionsLimited | 2 | 10 | #N/A | #N/A | |||
Sheet1 |