Results 1 to 2 of 2

Concatenate number with text, but keeping in number format

This is a discussion on Concatenate number with text, but keeping in number format within the Excel Questions forums, part of the Question Forums category; I am concatenating two fields in Excel using an '&' sign, where one is a number and one text. For ...

  1. #1
    New Member
    Join Date
    Jan 2006
    Posts
    2

    Default Concatenate number with text, but keeping in number format

    I am concatenating two fields in Excel using an '&' sign, where one is a number and one text.

    For example, using the formula =A1&A2 where

    cell A1 contains 'that costs '
    and cell A2 contains $50,000

    I want to display the sentence 'that costs $50,000'

    but instead it converts the number to text to display 'that costs 50000' which is no good to me.

    How can I simply set it up to display the '$' and the ','?

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    27,284

    Default

    Use the TEXT function to instruct Excel the format to use (currency):

    =A1 & TEXT(A2,"$#,##0")
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com