+ Reply to Thread
Results 1 to 4 of 4

Formula for sum of cells(text) from another sheet?

  1. 06-09-2012, 02:57 PM #1
    yenom2
    yenom2 is offline
    Registered User
    Join Date
    01-07-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    40

    Formula for sum of cells(text) from another sheet?

    I want to input in one cell(different sheet) a combination of cells B37(city) B38(state) B39(zip) from 'Data' Sheet but I want a space and a "," after the combination of cells

    What formula would be best?

    I tried using a =Data!$b37&$b38&$b39 but it did not work

    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 06-09-2012, 03:06 PM #2
    Russell Dawson
    Russell Dawson is offline
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Formula for sum of cells(text) from another sheet?

    Does this do it?

    =Data!$B37&", "&Data!$B38&", "&Data!$B39
    Last edited by Russell Dawson; 06-09-2012 at 03:08 PM. Reason: Missed space
    If I helped, please don't forget to add to my reputation. (click on the star below the post)

    If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.

    Failure is not falling down but refusing to get up.
    Reply With QuoteRegister To Reply
  3. 06-09-2012, 03:12 PM #3
    yenom2
    yenom2 is offline
    Registered User
    Join Date
    01-07-2012
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Formula for sum of cells(text) from another sheet?

    Thanks! worked like a charm!
    Reply With QuoteRegister To Reply
  4. 06-09-2012, 03:14 PM #4
    Russell Dawson
    Russell Dawson is offline
    Forum Contributor Russell Dawson's Avatar
    Join Date
    03-01-2012
    Location
    Yorkshire, England
    MS-Off Ver
    2007
    Posts
    608

    Re: Formula for sum of cells(text) from another sheet?

    My pleasure. Cheers.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1