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.