VBA- Export Excel table Rows to a text file in a specific format

[lstullwv]

I am needing help in exporting a table to a text file in a specific format.

The table is in the following order:[TABLE="width: 384"]
<tbody>[TR]
[TD="width: 64"]S[/TD]
[TD="width: 64, align: right"]45[/TD]
[TD="width: 64, align: right"]2[/TD]
[TD="width: 64, align: right"]58[/TD]
[TD="width: 64"]E[/TD]
[TD="width: 64, align: right"]297.74[/TD]
[/TR]
[TR]
[TD]N[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]11[/TD]
[TD]E[/TD]
[TD="align: right"]102.1[/TD]
[/TR]
</tbody>[/TABLE]


I am looking for an output in a text file of the following format:
The range can also be variable, i.e. the column count by remain the same, however, the number of rows containing information may increase.

S 45D 2' 58" E;297.74
N 59D 7' 11" E;102.1

Any help would be appreciated greatly.

Thanks.

 

[Joe4]

The easiest way may be to combine/concatenate all your fields into one column on another sheet, where you can add all the custom formatting you want directly by formula, then export that sheet, i.e.

=Sheet1!A1 & " " & Sheet!B1 & "D "  & Sheet1!C1 & "'" & ...