+ Reply to Thread
Results 1 to 3 of 3

Copy data to another column Macros

  1. #1
    Registered User
    Join Date
    11-02-2005
    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
    Attached Files Attached Files

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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
    Last edited by swatsp0p; 11-02-2005 at 04:02 PM.
    Bruce
    The older I get, the better I used to be.
    USA

  3. #3
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1