Home

Select many values in some cells quickly

%3CLINGO-SUB%20id%3D%22lingo-sub-443436%22%20slang%3D%22en-US%22%3ESelect%20many%20values%20in%20some%20cells%20quickly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all!%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20use%20the%20CONCATENATE%20function%20joining%20some%20cells.%20Sometimes%20are%202%20cells%2C%20other%20times%2010%20cells.%20I've%20to%20select%20all%20them%20one%20by%20one%20clicking%20and%20writing%20the%20symbol%20%3CSTRONG%3E%3B%3C%2FSTRONG%3E%20between%20the%20cells.%26nbsp%3B%3C%2FP%3E%3CP%3E%C2%BFDoes%20there%20is%20anyway%20to%20do%20it%20faster%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-443436%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-443455%22%20slang%3D%22en-US%22%3ERe%3A%20Select%20many%20values%20in%20some%20cells%20quickly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443455%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319936%22%20target%3D%22_blank%22%3E%40blackwolf88%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20are%20Office%20365%20subscriber%20you%20may%20use%20TEXTJOIN%3C%2FP%3E%3C%2FLINGO-BODY%3E
blackwolf88
Occasional Visitor

Hi all! 

I'm trying to use the CONCATENATE function joining some cells. Sometimes are 2 cells, other times 10 cells. I've to select all them one by one clicking and writing the symbol ; between the cells. 

¿Does there is anyway to do it faster? 

 

Thank you in advance!

1 Reply

@blackwolf88 , if you are Office 365 subscriber you may use TEXTJOIN

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies