ErnelandCopper ContributorOct 04, 2019Textjoin 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...Show More
PReaganBronze ContributorOct 04, 2019Hello Erneland, Let's say Cell A1=10kr and Cell B1=50kr. This would combine 10kr and 50kr as a text string:=CONCATENATE(A1," + ",B1)
