Re: Text file in two columns, how to seperate?

[a2mg@aol.comNomail (The Apple II Mail Group)]

>Press Control-@ (Control plus the 2/@ key shifted) to end recording of the
>"T"

This complicated keypress is no longer necessary to end the macro. In newer
versions of UltraMacros, Ctrl-X is a toggle, and can be used to both begin and
end a recorded macro.

Here's another scenario to separate two columns into one:

Starting at the first letter of column 2, record this macro:

Tab down OA-left

Repeat the macro all the way down column 2. Now you have a TAB on each line
between the two columns.

COPY the entire  text to the clipboard, and create a new spreadsheet. Copy the
data into the spreadsheet. Because of the TAB, the two columns will come in as
separate columns.

Use the spreadsheet's Block Move function to move column 2 to the foot of
column 1. Sort (arrange) alphabetically if necessary.

Beverly Cadieux 
http://members.aol.com/A2MG