<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16502"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana>I'm going to respond to my own post. This took so long to
get to the list, that I asked Rick Quatro if he'd seen it (thinking I'd
somehow missed it). He'd not seen, but great guy that he is, he took a few
minutes to discuss my problem and came up with a simple solution that will work
fine for my needs.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana>Here's what worked:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana>1. From the Excel worksheet with the list (all in one
column), save as to a text (tab delimited) file.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana>2. Import the file into FM using the copy option, selecting
Text as the type, then selecting a table format, make each para a
cell, and three columns. (Wrote that from memory, but if someone else needs
to do this, it should get you through the process).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana>Worked well and even got the alpha list to go alpha across
instead of down. Just what my client preferred.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=053012622-25082013><FONT color=#0000ff
size=2 face=Verdana>Thanks much, Rick!!</FONT></SPAN></DIV>
<DIV> </DIV>
<P align=left><A name=_MailAutoSig><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; mso-no-proof: yes">~~~~~~~~~~~~~~~~~~~~~~~~~<BR>Linda
G. Gallagher<BR>TechCom Plus, LLC<BR>lindag at techcomplus dot
com<BR></SPAN></A><A title=blocked::http://www.techcomplus.com/
href="http://www.techcomplus.com/"><FONT size=2><FONT face=Verdana><FONT
color=#0000ff><SPAN style="mso-bookmark: _MailAutoSig"><SPAN
style="mso-no-proof: yes">www.techcomplus.com</SPAN></SPAN><SPAN
style="mso-bookmark: _MailAutoSig"></SPAN></FONT></FONT></FONT></A><SPAN
style="mso-bookmark: _MailAutoSig"><SPAN
style="FONT-FAMILY: Verdana; FONT-SIZE: 10pt; mso-no-proof: yes">
<BR>303-450-9076 or
800-500-3144<BR>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR></SPAN></SPAN></P>
<DIV> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> framers-bounces@lists.frameusers.com
[mailto:framers-bounces@lists.frameusers.com] <B>On Behalf Of
</B>LGLists<BR><B>Sent:</B> Thursday, August 22, 2013 4:42 PM<BR><B>To:</B>
'Post Framers'<BR><B>Subject:</B> Convert 1 Excel column into 3 balanced columns
to paste into FM<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2 face=Verdana>Win
7</FONT></SPAN></DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2 face=Verdana>Excel
2003</FONT></SPAN></DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2 face=Verdana>FM
10</FONT></SPAN></DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2
face=Verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2 face=Verdana>I have a list of
117 or so items that I get from a client as a single column in an Excel
spreadsheet. I need to take that list and convert it to three balanced columns
(maintaining the alpha sort) to paste into FM.</FONT></SPAN></DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2
face=Verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2 face=Verdana>I did it once
manually, but the list keeps changing, so I'm looking for a way to easily
convert to three columns, so I can just copy and paste it into FM whenever it
changes. I'm think there's a way to do this in Excel, but my Excel knowledge
could fit on the point of a pin (not even the head of the
pin).</FONT></SPAN></DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2
face=Verdana></FONT></SPAN> </DIV>
<DIV><SPAN class=031213722-22082013><FONT size=2 face=Verdana>Anyone know how to
do that in Excel?</FONT></SPAN></DIV>
<DIV> </DIV>
<P align=left><FONT face=v><FONT size=2><FONT face=v><FONT
face=Verdana>~~~~~~~~~~~~~~~~~~~~~~~~~<BR>Linda G.
Gallagher<BR></FONT></FONT></FONT></FONT><FONT face=v><FONT size=2><FONT
face=v><FONT face=Verdana>STC Fellow</FONT></FONT></FONT></FONT><FONT
face=v><FONT size=2><FONT face=v><FONT face=Verdana><BR>TechCom Plus, LLC -
celebrating 20 years!<BR>lindag at techcomplus dot com<BR><A
title=blocked::http://www.techcomplus.com/
href="http://www.techcomplus.com/">www.techcomplus.com</A> <BR>303-450-9076 or
800-500-3144<BR>Tutorials, "show me" demos, user guides, help, FrameMaker and
WebWorks ePublisher
templates<BR>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<BR></P></FONT></FONT></FONT></FONT>
<DIV> </DIV></BODY></HTML>