+ Reply to Thread
Results 1 to 6 of 6

Combine data from diff cells into one cell

  1. #1
    Registered User
    Join Date
    06-08-2007
    Posts
    39

    Combine data from diff cells into one cell

    Dears,

    I need your help. I have 5 columns, each with some data. On the 6th column I need to combine the data from all 5 columns into column 6 to be as:

    Data in A2-Data in B2-Data in C2-Data in D2-Data in E2

    With one exception. column D is the date in this format 27-Aug-09

    I need the date to be modified on the fly from 27-Aug-09 to be 270809 which will be the info in D2

    See example attached. Can you help please. Thanks

    Sam
    Attached Files Attached Files
    Last edited by safisam; 08-30-2009 at 03:48 AM.

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    764

    Re: Combine data from diff cells into one cell

    Hi
    Try the macro in the attached file
    Ravi
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-08-2007
    Posts
    39

    Re: Combine data from diff cells into one cell

    Thank you, it worked perfect.

  4. #4
    Registered User
    Join Date
    06-08-2007
    Posts
    39

    Re: Combine data from diff cells into one cell

    Ravi,

    Can you fix the macro to only update the row that has information but does not have the final result (ie number). Thanks

+ 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