Concatenate number with text, but keeping in number format

[Haydon Waldek]

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 ','?

 

[Joe4]

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

=A1 & TEXT(A2,"$#,##0")

 

[psingh123]

Hi,

I am trying to use concatenate to add a number in % format after text. when I do that it gives me result with number appearing in decimal form instead of % form. e.g. "XYZ @ 1.02" instead I would like to see 102% in place of 1.02. Can you please help? thanks

 

[AhoyNC]

Welcome to the forum. It is usually best to start a new thread instead of adding to an old one.
See if this does what you want.

Excel Workbook
	A	B	C	D	E
1	XYZ @	102%		XYZ @ 102%
2
3
4
5
Sheet