Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Concatenate Number & Text

  1. #1
    Join Date
    6th July 2005
    Posts
    22

    Concatenate Number & Text

    Hi all,

    For example: A1 is $540,483.69780 and B1 is Acre, when I try to concatenate them together meaning (=A1&B2), the result is 540483.69780Acre. Is there anyway for me to concatenate these two cell so that the result will read $540,483.70 Acre? Meaninng I want to include the $ sign and the thousand separator (,).

    The problem is that when I try to concatenate a value cell with a text cell cell the result of the concatenation yield the value without the dollar sign and the thousand separator.

    Is there any way that it can be done WITHOUT USING VBA?

    An example of my problem is illustrate in the sample xls below.

    Thanks.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by kevphung; January 15th, 2006 at 14:28.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    28th January 2003
    Location
    India
    Posts
    1,038

    Re: Concatenate Number & Text

    Hi kevphung:

    Try this:
    =TEXT(B7,"#,##.00")& " " & "Acre"

    Regards

    Maqbool

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Concatenate Number & Text

    Try this.

    =TEXT(B7, "$###,###,###.00") & " Acre"

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    6th July 2005
    Posts
    22

    Re: Concatenate Number & Text

    Thanks.

    Someone shows me another method which involves:

    Using this if you want $ sign: =Dollar(B7,2)&" Acre"

    or using this if you don't want $ sign but you want to include 1000 separator: =Fixed(B7,2)&"Acre".

    Just want to share with everybody.

    Regards

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 2
    Last Post: May 25th, 2007, 04:07
  2. Concatenate Text
    By huntjumper in forum Excel and/or Access Help
    Replies: 2
    Last Post: January 18th, 2007, 20:57
  3. Concatenate Or Combinate Number A Cell Into Other Cells
    By scratchmaster in forum EXCEL HELP
    Replies: 3
    Last Post: September 20th, 2006, 13:10
  4. Concatenate text and numbers
    By vicelly in forum EXCEL HELP
    Replies: 7
    Last Post: April 10th, 2006, 23:50
  5. Concatenate variable number of cells
    By soberguy in forum EXCEL HELP
    Replies: 1
    Last Post: December 28th, 2005, 05:38

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
  •  
porno