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

Most users of this forum will NOT open zipped files (especially those
containing macros). Please be very descriptive, maybe attach a
screenshot (.jpg), etc. We can generally help just as well that way.

No offense, but zipped files are notorious for viruii.

Good Luck


--
swatsp0p


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

I do have a possible solution without looking at your sheet.... try
"Text to Columns" to split your data. Depending on the layout, you
could use a space as a delimiter.

Check it out... on the main menu: DataText to columns...

Good Luck.


--
swatsp0p


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