Copy data to another column Macros

[dominoguru2]

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 |
+-------------------------------------------------------------------+

 

[swatsp0p]

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]

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: Data>Text to columns...

Good Luck.