How to combine text and the value in another cell?

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Excel 2007

Lets say in A2 I have a calculated value of 2

in A1 I want it to say The total of XX = 2

This is what I tried:

=CONCATENATE(The Total of XX =,A2)

Gave me a "value" error

what other approach should I try?

tia

dave
 
Try this:

="The total of xx = "&A2
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Excel 2007

Lets say in A2 I have a calculated value of 2

in A1 I want it to say The total of XX = 2

This is what I tried:

=CONCATENATE(The Total of XX =,A2)

Gave me a "value" error

what other approach should I try?

tia

dave
 
Whenever you specify text, that text must be wrapped in quote marks. This
would have worked for you...

=CONCATENATE("The Total of XX = ",A2)

but it is usually much easier to use an ampersand sign (&) to link text and
not use the CONCATENATE function (the rule about text in quotes still
holds), so you could do this instead...

="The Total of XX = "&A2

Rick
 
And just in case you need that value formatted:

="The total is: " & text(a2,"$0.00")
 
Back
Top