Forum Discussion

Copper Contributor

Oct 04, 2019

Textjoin with currency

Hi! I've been trying to use the function "Textjoin" on two cells with currencies. When i join the cells it combines the numbers but not the currency. I've also been trying to add the funtion "Do...

excel

Formulas and Functions

Haytham Amairah

Silver Contributor

Oct 04, 2019

Erneland

Hi,

You can wrap each cell with the TEXT function using the specific currency format that you want as follows:

=TEXTJOIN(" + ",TRUE,TEXT(A1,"[$kr-smj-NO] #,##0"),TEXT(A2,"[$kr-smj-NO] #,##0"))

Or you can use this one instead to wrap the range of cells in one TEXT function:

=TEXTJOIN(" + ",TRUE,INDEX(TEXT(A1:A2,"[$kr-smj-NO] #,##0"),))

Hope that helps