SOLVED

Excel no longer accepting a combine cells command?

%3CLINGO-SUB%20id%3D%22lingo-sub-2360672%22%20slang%3D%22en-US%22%3EExcel%20no%20longer%20accepting%20a%20combine%20cells%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360672%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Community%2C%3C%2FP%3E%3CP%3EI%20have%20a%20very%20large%20file%20in%20which%20I%20have%20entered%20dates%20in%20three%20columns%20(day%20month%20and%20year)%20I%20am%20attempting%20to%20turn%20these%20into%20ISO%20weeks.%20Two%20days%20ago%20I%20used%20the%20formula%20suggested%20to%20combine%20cells%20and%20then%20added%20a%20%2F%20to%20replace%20the%20spaces%20and%20then%20used%20a%20small%20macro%20to%20generate%20iso%20week%20numbers%20but%20the%20program%20crashed%20when%20I%20attempted%20to%20then%20sort%20and%20copy%20the%20weekly%20means%20(on%20numbers%20of%20mosquitoes)%20and%20stupidly%20not%20having%20saved%20the%20file%20as%20I%20went%20along%20I%20lost%20it%20all.%20Today%20I%20have%20tried%20again%20using%20the%20%3DCell%26amp%3B%22%20%22Cell%26amp%3B%22%20%22%20Cell%20formula%20and%20keep%20getting%20an%20error%20message.%20I%20have%20made%20sure%20that%20all%20the%20cells%20are%20seen%20as%20numbers%20etc%20but%20still%20get%20the%20error%20message.%20It%20worked%202%20days%20ago.%20What%20am%20I%20doing%20wrong%3F%20Thank%20you%20for%20any%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2360672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360704%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20no%20longer%20accepting%20a%20combine%20cells%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1055779%22%20target%3D%22_blank%22%3E%40jdcharlwood%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20forget%20the%20%26amp%3B%20after%20each%20part%20of%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E%3DCell%26amp%3B%22%20%22%26amp%3BCell%26amp%3B%22%20%22%26amp%3BCell%3C%2FSTRONG%3E%20should%20work.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2360705%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20no%20longer%20accepting%20a%20combine%20cells%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2360705%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%2F1055779%22%20target%3D%22_blank%22%3E%40jdcharlwood%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20made%20it%20wrong.%20You%20have%20to%20write%20for%20example%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3EA2%26amp%3B%22%20%22%26amp%3BB2%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20you%20can%20also%20check%20out%20the%20official%20documentation%2C%20where%20it's%20explained%20again%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcombine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcombine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3CBR%20%2F%3ESchnittlauch%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2361583%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20no%20longer%20accepting%20a%20combine%20cells%20command%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2361583%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks.%20I%20managed%20to%20concatenate%20the%20data.%20My%20apologies%20for%20using%20your%20time%20-%20I%20hope%20that%20I%20can%20still%20count%20on%20your%20help%20in%20future.%20My%20best%20wishes%2C%20Derek%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1055779%22%20target%3D%22_blank%22%3E%40jdcharlwood%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Dear Community,

I have a very large file in which I have entered dates in three columns (day month and year) I am attempting to turn these into ISO weeks. Two days ago I used the formula suggested to combine cells and then added a / to replace the spaces and then used a small macro to generate iso week numbers but the program crashed when I attempted to then sort and copy the weekly means (on numbers of mosquitoes) and stupidly not having saved the file as I went along I lost it all. Today I have tried again using the =Cell&" "Cell&" " Cell formula and keep getting an error message. I have made sure that all the cells are seen as numbers etc but still get the error message. It worked 2 days ago. What am I doing wrong? Thank you for any help

 

3 Replies

@jdcharlwood 

 

Don't forget the & after each part of the formula.

 

=Cell&" "&Cell&" "&Cell should work.

best response confirmed by allyreckerman (Microsoft)
Solution

Hi @jdcharlwood,

 

You made it wrong. You have to write for example:

A2&" "&B2

 

but you can also check out the official documentation, where it's explained again:

 

https://support.microsoft.com/en-us/office/combine-text-from-two-or-more-cells-into-one-cell-81ba094...

 

Best regards,
Schnittlauch

 

"First, No system is safe. Second, Aim for the impossible. Third no Backup, no Mercy" - Schnittlauch

 

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved.

Many thanks. I managed to concatenate the data. My apologies for using your time - I hope that I can still count on your help in future. My best wishes, Derek @jdcharlwood