[UK-CONTEST] Excel to Cabrillo (text) file - help pse?

[Don Field]

Trivial Nigel - Paste-special (unformatted text) into Ultraedit or
equivalent, and you can then manipulate the columns to your heart's content.
I do it all the time when people send Excel logs for the IOTA contest.

73 Don G3XTT

----- Original Message -----
From: "Nigel G3TXF" <nigel at G3TXF.com>
To: "Chris Tran ZL1CT" <zl1ct at gm7v.com>
Cc: "UK Contest Reflector" <uk-contest at contesting.com>
Sent: Tuesday, March 01, 2005 10:18 AM
Subject: [UK-CONTEST] Excel to Cabrillo (text) file - help pse?


> Hullo Chris,
>
> Could you (or anyone else on the UK Contest Reflector) pse help me to
export
> an Excel file into a "Cabrillo compatible text-file"?
>
> I have been trying to do this with Word's Mail-Merge, but Mail-Merge gives
> you separate file for each line entry, and what I need is all the entries
> from the log in one flat text file.
>
> I realise that this is easy enough for those that know how - but I don't!
>
> I have all my DX-Trip Logs in Access and now want to up-load them to LoTW.
> Exporting from Access in Excel is no problem, but getting from Excel into
a
> Cabrillo-style flat text file is where I need help!
>
> 73 - Nigel G3TXF
>
> ----- Original Message -----
> From: "Chris Tran ZL1CT" <zl1ct at gm7v.com>
> To: "Tom Wylie" <t.wylie at ntlworld.com>; <uk-contest at contesting.com>
> Sent: Tuesday, March 01, 2005 4:52 AM
> Subject: Re: [UK-CONTEST] Easy question
>
>
> > Hi Tom
> >
> > I have not actually done this, but one procedure would be :-
> > 1. Export the Excel spreadsheet data to a Cabrillo compatible text-file
> > 2. Use WT4I tools to check this file, then save as a Cabrillo log-file
> > 3. Import the Cabrillo log-file into logging software (Writelog cannot
> > import Cabrillo)
> > 4. Export as a .adi file
> >
> > There must be an easier way to do this..... ?
> >
> > 73
> > Chris
> > ZL1CT
> >
> > ----- Original Message -----
> > From: "Tom Wylie" <t.wylie at ntlworld.com>
> > To: <uk-contest at contesting.com>
> > Sent: Tuesday, March 01, 2005 10:56 AM
> > Subject: [UK-CONTEST] Easy question
> >
> >
> >> How can I convert from an Excel file to an ADIF?
> >>
> >> tom
> >> gm4fdm
> >>
> >> _______________________________________________
> >> UK-Contest mailing list
> >> UK-Contest at contesting.com
> >> http://lists.contesting.com/mailman/listinfo/uk-contest
> >
> > _______________________________________________
> > UK-Contest mailing list
> > UK-Contest at contesting.com
> > http://lists.contesting.com/mailman/listinfo/uk-contest
> >
> >
>
>
> _______________________________________________
> UK-Contest mailing list
> UK-Contest at contesting.com
> http://lists.contesting.com/mailman/listinfo/uk-contest
>