+ Reply to Thread
Results 1 to 3 of 3

Consolidate values from multiple cells

  1. #1
    Registered User
    Join Date
    01-24-2007
    Location
    Melbourne, Australia
    Posts
    74

    Consolidate values from multiple cells

    I'm not sure if this can be done but if I had the numbers 1, 2, 3, 4 and 5 in cells A1, A2, A3, A4 and A5 respectively, is there a formula that I could put in another cell to display "12345"?
    I was playing around with the consolidate function, but I couldn't get it to work, and it's not a formula, it is done after the fact.
    (PS. I've got no idea about macros)
    Thanks in advance
    Jase

    SEE ATTACHMENT
    Attached Files Attached Files
    Last edited by VBA Noob; 10-28-2008 at 06:39 PM.

  2. #2
    Registered User
    Join Date
    10-28-2008
    Location
    Dallas
    Posts
    7
    =A1&A2&A3&A4&A5

    This will return a text string "12345". If it can be converted to a number and you need to do so;

    =1*(A1&A2&A3&A4&A5)

    Hope this helps.

  3. #3
    Registered User
    Join Date
    01-24-2007
    Location
    Melbourne, Australia
    Posts
    74
    Thanks mate you're a legend!
    Last edited by jasonmcbride; 10-28-2008 at 06:36 PM. Reason: spelling

+ 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