Oct 04 2019 05:24 AM
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 "Dollar" with the help of various guides on youtube and in forums. One forum suggested using the combination "Textjoin" and "Text" but I wont get it to work. Can someone please help me? I'm pulling my hair here.
The cells are listed like below
10kr
50kr
I want it to result in
10kr + 50kr.
Oct 04 2019 06:04 AM
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
Oct 04 2019 06:07 AM
Hello @Erneland,
Let's say Cell A1=10kr and Cell B1=50kr. This would combine 10kr and 50kr as a text string:
=CONCATENATE(A1," + ",B1)
Oct 04 2019 06:09 AM