Even with the data all in one column you could still parse the it into
separate columns. Excel 2007 calls this "text to columns". I've forgotten
what Excel 2003 calls it.
In Excel, select column to be parsed. On the data tab select text to columns.
Click the delimited radio button and on the next screen, choose "space" as
the delimiter. Then click finish.
I don't know which is faster. But both Word and Excel can easily and quickly
do the task.
PamC
DeanH wrote:
From your inital description you did say that there is a tab between the
columns.
I copied your text and inserted the required Tab between the columns, went
to Excel I actually got the required result by using Paste Special - Text.
Hope this helps
DeanH
On May 12, 4:47 am, "Doug Robbins - Word MVP"
wrote:
[quoted text clipped - 41 lines]
regards,
Vishwas
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...gdocs/200805/1