Please see the excel files in attachment. I have a worksheet that has 2
lines in each cell. I would like to move the line below to another
column.

For instance

Cell 1 data
teststest
54545

I need to move 54545 to another a new column on the same row.


I have attached the sample excel file and the sample_complete file (the
needed results)

I believe I have to create a macro. I never done this before. Please
help

Huan


+-------------------------------------------------------------------+
|Filename: sampleexcel.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3985 |
+-------------------------------------------------------------------+

--
dominoguru2
------------------------------------------------------------------------
dominoguru2's Profile: http://www.excelforum.com/member.php...o&userid=28510
View this thread: http://www.excelforum.com/showthread...hreadid=481016