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 |
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 |
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 |
All times are GMT +1. The time now is 12:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com