Hi and Welcome

If you are new to the forum these may be of interest:
http://www.cpearson.com/excel/newposte.htm
http://www.cpearson.com/excel/Attachments.htm

Having read those you may want to post back with a description of what
your data looks like now and how you would like it to look when you are
finished.

Good luck
Rowan

jdecambra wrote:
whats up everyone, im new to the forum and i have to say this is an
awesome forum. thanks in advance to anyone that lends their help.
thanks!

i have this project im working on where i need data thats listed on one
colum to be broken into more than one colum. i have an example if
someone can take a look at it. its located at

http://www.jaysondecambra.com/EXCELMACROTEST.xls

if you look at sheet 1 all the data is listed in colum a. i would like
it to look like sheet 2. is this possible? oh in the real book i have
more than 3200 rows not just one like the test. thanks again for
anyhelp guys!!!