Concatenate Formula

  • Thread starter Thread starter Manos
  • Start date Start date
M

Manos

Dear all,
Does anyone no if in a field of a concatenate formula i
can make a sum function?
eg: in the first text i add the word Euro
and in the second field i want to add a sum of two
differenct cells

there is anyway i can do this work?

Regards
Manos
 
Hi Manos
one way:
="Euro " & TEXT(A1+B1,"0,00")
but wouldn't a cell format better suited for your need. So just simply
add your cells and format the resulting cell as currency (goto
'Format - Cells')

HTH
Frank
 
Manos said:
Dear all,
Does anyone no if in a field of a concatenate formula i
can make a sum function?
eg: in the first text i add the word Euro
and in the second field i want to add a sum of two
differenct cells

there is anyway i can do this work?

Regards
Manos
Click to expand...

Don't use CONCATENATE here. Instead, try something such as
="Euro"&(A1+B1)
 
Back
Top