Home

Textjoin with currency

%3CLINGO-SUB%20id%3D%22lingo-sub-893253%22%20slang%3D%22en-US%22%3ETextjoin%20with%20currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893253%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20trying%20to%20use%20the%20function%20%22Textjoin%22%20on%20two%20cells%20with%20currencies.%20When%20i%20join%20the%20cells%20it%20combines%20the%20numbers%20but%20not%20the%20currency.%20I've%20also%20been%20trying%20to%20add%20the%20funtion%20%22Dollar%22%20with%20the%20help%20of%20various%20guides%20on%20youtube%20and%20in%20forums.%20One%20forum%20suggested%20using%20the%20combination%20%22Textjoin%22%20and%20%22Text%22%20but%20I%20wont%20get%20it%20to%20work.%20Can%20someone%20please%20help%20me%3F%20I'm%20pulling%20my%20hair%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20cells%20are%20listed%20like%20below%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E10kr%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E50kr%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20result%20in%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E10kr%20%2B%2050kr.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-893253%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893316%22%20slang%3D%22en-US%22%3ERe%3A%20Textjoin%20with%20currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893316%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420095%22%20target%3D%22_blank%22%3E%40Erneland%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20wrap%20each%20cell%20with%20the%20TEXT%20function%20using%20the%20specific%20currency%20format%20that%20you%20want%20as%20follows%3A%3C%2FP%3E%3CPRE%3E%3DTEXTJOIN(%22%20%2B%20%22%2CTRUE%2CTEXT(A1%2C%22%5B%24kr-smj-NO%5D%20%23%2C%23%230%22)%2CTEXT(A2%2C%22%5B%24kr-smj-NO%5D%20%23%2C%23%230%22))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOr%20you%20can%20use%20this%20one%20instead%20to%20wrap%20the%20range%20of%20cells%20in%20one%20TEXT%20function%3A%3C%2FP%3E%3CPRE%3E%3DTEXTJOIN(%22%20%2B%20%22%2CTRUE%2CINDEX(TEXT(A1%3AA2%2C%22%5B%24kr-smj-NO%5D%20%23%2C%23%230%22)%2C))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893318%22%20slang%3D%22en-US%22%3ERe%3A%20Textjoin%20with%20currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893318%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420095%22%20target%3D%22_blank%22%3E%40Erneland%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20say%20Cell%20A1%3D10kr%20and%20Cell%20B1%3D50kr.%20This%20would%20combine%2010kr%20and%2050kr%20as%20a%26nbsp%3B%3CEM%3E%3CU%3Etext%20string%3A%3C%2FU%3E%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3DCONCATENATE(A1%2C%22%20%2B%20%22%2CB1)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893326%22%20slang%3D%22en-US%22%3ERe%3A%20Textjoin%20with%20currency%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893326%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420095%22%20target%3D%22_blank%22%3E%40Erneland%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20spreadsheet%20with%20I%20hope%20will%20answer%20your%20question%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERich%2099%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Erneland
Occasional Visitor

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. 

 

 

3 Replies

@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

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)

Hi @Erneland 

 

I have attached a spreadsheet with I hope will answer your question

 

Rich 99

Related Conversations
Removing duplicates when using TEXTJOIN
Kirsty Lowe in Excel on
6 Replies
Removing TEXTJOIN duplicates with multiple rows
Ben Taylor in Excel on
4 Replies
Issue with Textjoin, multiple criteria. IF/AND function
MrRAMMount in Excel on
13 Replies
TEXTJOIN function not ignoring blank cells
lissajo64 in Excel on
3 Replies
TextJoin Partial Matches?
meklund in Excel on
6 Replies
TEXTJOIN formula that incorporates a look up?
Andrew Nhan in Excel on
3 Replies