Concatenate Help

slinkyjib

Board Regular
Joined
Aug 2, 2004
Messages
161
Good morning,
I'm trying to do a simple concatenate formula, but I'm having a problem.
The formula I am using is below;

=CONCATENATE("TYPE: ",R2," SIZE: ",T2," SUPPLIER: ",X2," UNIT PRICE: ",U2," BIN NUMBER: ",W2)

This formula works, but in cell U2, I have a currency value.e.g. 1.00 or 2.50
When the formula concatenates it puts the value of U2 in as 1 or 2.5
Is there anyway to get it to display the vaule of the cell including the zero's?

Even tried the old "" but then I just get U2 in the concatenated formula... :confused:

any help appreciatted.

oh and merry xmas all....... :biggrin:
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Try this:

=CONCATENATE("TYPE: ",R2," SIZE: ",T2," SUPPLIER: ",X2," UNIT PRICE: ",TEXT(U2,"0.00")," BIN NUMBER: ",W2)

Regards

Richard
 

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,741
Members
412,482
Latest member
arooshrana2
Top