+ Reply to Thread
Results 1 to 4 of 4

Adding Commas into an "Equation Sentence"

  1. #1
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    224

    Adding Commas into an "Equation Sentence"

    Let me start off by saying, sorry about the title of this thread

    I'm not sure if there's an actual name for this type of function where you have:

    =A1 & " plus " & A2 & " equals " A3


    What I'm looking to do is have the result include commas for the numbers


    In excel, if you have:

    A1=1,000
    A2=5,000
    A3=6,000

    this formula above will result in:

    1000 plus 5000 equals 6000

    as opposed to:

    1,000 plus 5,000 equals 6,000


    Any idea how to achieve this result?


    Thank you so much for your time and efforts,
    Bob
    Last edited by sighlent1; 05-17-2011 at 04:45 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Adding Commas into an "Equation Sentence"

    =TEXT(A1,"#,##0") & " plus " & TEXT(A2,"#,##0") & " equals " & TEXT(A3,"#,##0")


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    02-11-2009
    Location
    Montclair, NJ
    MS-Off Ver
    Excel 365
    Posts
    224

    Re: Adding Commas into an "Equation Sentence"

    Excellent!

    That's EXACTLY what I am looking for

    Thank you sooo much TMShucks!!!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Adding Commas into an "Equation Sentence"

    You're welcome.

+ 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