I have just exported some 200 contacts from Word document into Excel sheet and they look somewhat like this:
[TABLE="width: 272"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Title: Mr. [/TD]
[/TR]
[TR]
[TD]First name: R[/TD]
[/TR]
[TR]
[TD]Last name: Miles [/TD]
[/TR]
[TR]
[TD]Email address: rmiles@*** [/TD]
[/TR]
[TR]
[TD]Address 1: 1 Lane [/TD]
[/TR]
[TR]
[TD]Address 2: Burton [/TD]
[/TR]
[TR]
[TD]Postcode: E** 8*K [/TD]
[/TR]
[TR]
[TD]Town: Somewhere [/TD]
[/TR]
[TR]
[TD]State / Province: UK [/TD]
[/TR]
[TR]
[TD]Country: United Kingdom [/TD]
[/TR]
[TR]
[TD]Phone : +44 78504*****
All of this info is in cell A1 - A11, where the fields and the information given aren't separated into different columns.
This is repeated for the other 200 contacts. Meaning to say, the information starts at A1 and ends at A498.
I am trying to create a database that would allow me to extract all this information and allocate them neatly into fields in columns. Does anyone know how to extract this or use a macro that could make the task easier so I don't have to manually fill in 200 contacts into the respective fields?
Thanks! [/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 272"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Title: Mr. [/TD]
[/TR]
[TR]
[TD]First name: R[/TD]
[/TR]
[TR]
[TD]Last name: Miles [/TD]
[/TR]
[TR]
[TD]Email address: rmiles@*** [/TD]
[/TR]
[TR]
[TD]Address 1: 1 Lane [/TD]
[/TR]
[TR]
[TD]Address 2: Burton [/TD]
[/TR]
[TR]
[TD]Postcode: E** 8*K [/TD]
[/TR]
[TR]
[TD]Town: Somewhere [/TD]
[/TR]
[TR]
[TD]State / Province: UK [/TD]
[/TR]
[TR]
[TD]Country: United Kingdom [/TD]
[/TR]
[TR]
[TD]Phone : +44 78504*****
All of this info is in cell A1 - A11, where the fields and the information given aren't separated into different columns.
This is repeated for the other 200 contacts. Meaning to say, the information starts at A1 and ends at A498.
I am trying to create a database that would allow me to extract all this information and allocate them neatly into fields in columns. Does anyone know how to extract this or use a macro that could make the task easier so I don't have to manually fill in 200 contacts into the respective fields?
Thanks! [/TD]
[/TR]
</tbody>[/TABLE]