Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Copy data to another column Macros
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 |
#2
|
|||
|
|||
Copy data to another column Macros
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 |
#3
|
|||
|
|||
Copy data to another column Macros
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy data from one column to another without overlaying? | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |