Thankyou for your suggestion however i am still having trouble keeping
keeping the collums in line ,i followed the ^w then ^t every thing work till
the second replace then the misallinment starts ,thank in advance for any
futher assistance.
Regards Kel

"wjohnson" wrote:


In your word document do a find and replace:
In the following the ^w will find "all white space"
In the following the ^t will insert a "tab mark"
In the Find Box enter ^w
In the Replace Box enter ^t
After this is done - Select all of your document and go to the Menu Bar
and Select TABLE - CONVERT - TEXT TO TABLE.
This will put your document into a table - then you can copy the table
- paste into EXCEL and move the columns around as necessary.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=521281