[Dx4win] QSL-manager-files from Excel
SM5DJZ Jan/John
[email protected]
Thu, 03 Apr 2003 22:55:31 +0200
May I ask You about some probably very simple Excel-question that I have.
I am trying to import the QSL-manager-info taken from a 425DXNews
into the QSL-manager database of DX4WIN.
First I copy the whole list into an excel-file and divide the info into 6
fifferent columns
Then I cut column # 3 to 6 and paste this info on to col # 1
Finally I cut this column #3 and 4 and past them into # 1 again.
In this way I end up having all DX under each other in col #1 and the
manager in col#2.
Easy!
Now I can insert a new column between the two and add a double-comma here.
Finally I can save the whole sheet and make it a .txt-file but here comes
my problem.
This txt-file is having a lot of space between the DX-call, the
double-comma and the manager.
Like
XX1X ,, YY2YY
ZZ1Z ,, WW1WW
Can anyone explain to me how I shall do to receive a text-file looking like
XX1X,,YY2YY
ZZ1Z,,WW1WW
because that's the only way DX4WIN will accept my import.
This is a file like UA6JD earlier sent us on this refelctor, but for some
reason he has stopped.
Thank's for any help out there.
73 de SM5DJZ John