Parsing text file into excel

hi everyone,Happy Holidays..just wondering if I can get some Christmastime cheer..

I am trying to get this text file parsed into excel , I want each line of a order into separate columns.
demarcated by 1) 2) indicating the next row etc....

like 1) 601-408867 CUSTOMER NAME 14 LANGMAID CRT WHITBY ON ABC 123 TIM PARK 900T 2012/12/12 12/21/2012 2:51:14 PM WHITE WEST WRT8G3EW etc..



1 )
601-408867
CUSTOMER NAME
14 LANGMAID CRT WHITBY ON ABC 123
TIM PARK 900T
2012/12/12 12/21/2012 2:51:14 PM
WHITE WEST WRT8G3EW
00000010060402688883
2 )
768-901732
CUSTOMER NAME
14 LANGMAID CRT WHITBY ON ABC 123
TIM PARK 900T
2012/12/12 12/21/2012 2:51:14 PM
WHITE WEST WRT8G3EW
00000010060402688883
3 )
768-901732
CUSTOMER NAME
14 LANGMAID CRT WHITBY ON ABC 123
TIM PARK 900T
2012/12/12 12/21/2012 2:51:14 PM
WHITE WEST WRT8G3EW
00000010060402688883

try the macro included

Here's my interpretatoion

Please Login or Register  to view this content.

both of these work awesome.. God Bless you all this Holiday Season!
Merry Christmas to you all !!