CONCAT Function Not Working

%3CLINGO-SUB%20id%3D%22lingo-sub-1110333%22%20slang%3D%22en-US%22%3ECONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110333%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20Office%20365%20here%20(installed%20on%20PC).%3C%2FP%3E%3CP%3EEntering%26nbsp%3B%3DCONCAT(G2%2C%22%20%22%2CH2)%20to%20join%20the%20two%20text%20values%20in%20these%20cells%20and%20when%20clicking%20enter%20the%20formula%20appears%20in%20the%20cell%2C%20not%20a%20string%20of%20the%20two%20words%20in%20the%20cells%20I%20want%20to%20combine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20tried%20%3DG2%26amp%3B%2C%22%20%22%2C%26amp%3BH2%2C%20and%20showing%20formula%20in%20cell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20else%20experiencing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1110333%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-1110454%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110454%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F519639%22%20target%3D%22_blank%22%3E%40AdiAtNoname%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3ENot%20sure%20what%20you're%20experiencing%20on%20your%20side%20but%20this%20is%20what%20I%20get%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20517px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F165495i14666FBBB21EBB08%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%223.png%22%20title%3D%223.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EYou%20don't%20need%20the%20commas%20when%20using%20%26amp%3B%20to%20join.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1110865%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1110865%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F519639%22%20target%3D%22_blank%22%3E%40AdiAtNoname%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eif%20you%20see%20formula%20instead%20of%20the%20result%20please%20be%20sure%20this%20setting%20is%20not%20checked%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20682px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F165520i8EC540204E69E655%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282797%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F519639%22%20target%3D%22_blank%22%3E%40AdiAtNoname%3C%2FA%3E%26nbsp%3BSame%20problem%20here%20using%20Excel%202016.%26nbsp%3BI%20tried%20to%20combine%20two%20columns%20of%20data%20into%20one%20using%20the%20%3DA2%26amp%3B%22%20%22%26amp%3BB2%20formula%20example%2C%20and%20also%20tried%20%3Dconcat(A2%2C%22%20%22%2CB2)%20and%20neither%20are%20working.%20When%20I%20hit%20enter%20all%20it%20shows%20is%20the%20formula%20I%20entered.%20I%20have%20also%20check%20to%20make%20sure%20the%20Show%20Formulas%20button%20is%20not%20selected.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282816%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282816%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610083%22%20target%3D%22_blank%22%3E%40Lauraleiwhit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20variant%20if%20your%20cell%20is%20formatted%20as%20text.%20Check%20by%20Ctrl%2B1.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282821%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BAll%20data%20in%20both%20columns%20are%20formatted%20as%20text.%20But%20here's%20what%20just%20happened.%20I%20tried%20the%20formula%20in%20a%20blank%20worksheet%20and%20it%20worked.%20Then%20when%20I%20went%20back%20to%20my%20data%20worksheet%20to%20try%20again%2C%20it%20finally%20worked.%20I%20entered%20the%20same%20formula%20again%20and%20viola%2C%20it%20worked.%20I%20don't%20know%20why%20this%20was%20the%20case.%20I%20had%20originally%20typed%20in%20the%20cell%20references%20instead%20of%20selecting%20them%20by%20clicking%20on%20them.%20Is%20this%20possibly%20the%20trick%3F%3F%3CBR%20%2F%3ERegardless%2C%20my%20problem%20is%20solved.%3CBR%20%2F%3EThis%20might%20help%20someone%20else%20though%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282855%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282855%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610083%22%20target%3D%22_blank%22%3E%40Lauraleiwhit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20not%20with%20the%20referenced%20cells%20being%20formatted%20as%20text%3B%20it%20is%20likely%20that%20the%20formula%20cell%20was%20accidentally%20formatted%20as%20text%20which%20will%20block%20any%20formula%20you%20may%20enter%20into%20that%20cell%20from%20working.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282860%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282860%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214174%22%20target%3D%22_blank%22%3E%40Peter%20Bartholomew%3C%2FA%3E%26nbsp%3BI%20did%20check%20that%20when%20I%20was%20trying%20to%20troubleshoot%20and%20I%20believe%20it%20was%20set%20as%20General.%26nbsp%3BSo%20how%20should%20the%20formula%20cell%20be%20formatted%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1282903%22%20slang%3D%22en-US%22%3ERe%3A%20CONCAT%20Function%20Not%20Working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1282903%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F610083%22%20target%3D%22_blank%22%3E%40Lauraleiwhit%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGeneral%20should%20be%20fine.%26nbsp%3B%20There%20is%20a%20catch%20in%20that%20reinstating%20General%20in%20place%20of%20Text%20doesn't%20automatically%26nbsp%3B%20sort%20the%20problem.%26nbsp%3B%20The%20formula%20also%20has%20to%20be%20committed%20with%20Enter%20as%20if%20it%20were%20newly%20input.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi,

 

Using Office 365 here (installed on PC).

Entering =CONCAT(G2," ",H2) to join the two text values in these cells and when clicking enter the formula appears in the cell, not a string of the two words in the cells I want to combine.

 

Also tried =G2&," ",&H2, and showing formula in cell.

 

Anyone else experiencing this?

 

Thank you.

8 Replies
Highlighted

@AdiAtNoname -

Not sure what you're experiencing on your side but this is what I get:

3.png

You don't need the commas when using & to join.

Highlighted

@AdiAtNoname 

if you see formula instead of the result please be sure this setting is not checked

image.png

Highlighted

@AdiAtNoname Same problem here using Excel 2016. I tried to combine two columns of data into one using the =A2&" "&B2 formula example, and also tried =concat(A2," ",B2) and neither are working. When I hit enter all it shows is the formula I entered. I have also check to make sure the Show Formulas button is not selected. 

Highlighted

@Lauraleiwhit 

Another variant if your cell is formatted as text. Check by Ctrl+1.

Highlighted

@Sergei Baklan All data in both columns are formatted as text. But here's what just happened. I tried the formula in a blank worksheet and it worked. Then when I went back to my data worksheet to try again, it finally worked. I entered the same formula again and viola, it worked. I don't know why this was the case. I had originally typed in the cell references instead of selecting them by clicking on them. Is this possibly the trick??
Regardless, my problem is solved.
This might help someone else though??

Highlighted

@Lauraleiwhit 

The problem is not with the referenced cells being formatted as text; it is likely that the formula cell was accidentally formatted as text which will block any formula you may enter into that cell from working.

Highlighted

@Peter Bartholomew I did check that when I was trying to troubleshoot and I believe it was set as General. So how should the formula cell be formatted? 

Highlighted

@Lauraleiwhit 

General should be fine.  There is a catch in that reinstating General in place of Text doesn't automatically  sort the problem.  The formula also has to be committed with Enter as if it were newly input.