Home

formulas automatically splitting into cells

%3CLINGO-SUB%20id%3D%22lingo-sub-657662%22%20slang%3D%22en-US%22%3Eformulas%20automatically%20splitting%20into%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657662%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20copy%20part%20of%20a%20formula%20that%20includes%20commas%20into%20another%20cell.%26nbsp%3B%20Whenever%20I%20paste%20the%20copied%20formula%20into%20the%20new%20cell%2C%20it%20automatically%20splits%20%26amp%3B%20puts%20it%20into%20several%20cells%20based%20on%20the%20commas.%26nbsp%3B%20How%20do%20I%20stop%20it%20doing%20this%3F%26nbsp%3B%20It's%20only%20just%20started%20doing%20it%20today.%26nbsp%3B%20Not%20sure%20if%20I%20have%20turned%20something%20on%20by%20accident%20but%20how%20do%20I%20turn%20if%20off%3F!%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-657662%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
jacq316
Occasional Visitor

I'm trying to copy part of a formula that includes commas into another cell.  Whenever I paste the copied formula into the new cell, it automatically splits & puts it into several cells based on the commas.  How do I stop it doing this?  It's only just started doing it today.  Not sure if I have turned something on by accident but how do I turn if off?!

Thanks

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies