Combining text from different cells into one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1434636%22%20slang%3D%22en-US%22%3ECombining%20text%20from%20different%20cells%20into%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434636%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20combine%20text%20from%20multiple%20cells%20into%20one%2C%20but%20the%20information%20in%20excel%20help%20is%20not%20working.%26nbsp%3B%20How%20would%20I%20accomplish%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1434636%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434766%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20text%20from%20different%20cells%20into%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687097%22%20target%3D%22_blank%22%3E%40Chris_Hafstein%3C%2FA%3E%26nbsp%3B%20there%20are%20a%20few%20options%3A%3C%2FP%3E%3CP%3E%3D%20A1%20%26amp%3B%20B1%3C%2FP%3E%3CP%3E%3D%20concat%20(A1%2C%20B1)%3C%2FP%3E%3CP%3E%3D%20concatenate%20(A1%2C%20B1)%3C%2FP%3E%3CP%3E%3D%20textjoin%20(%22%22%2Ctrue%2CA1%2C%20B1)%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1438715%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20text%20from%20different%20cells%20into%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1438715%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687097%22%20target%3D%22_blank%22%3E%40Chris_Hafstein%3C%2FA%3EYou%20could%20also%20use%20Flash%20Fill.%20In%20a%20cell%20type%20what%20you%20want%20the%20answer%20to%20look%20like.%20With%20the%20cell%20selected%20click%20Data%20%26gt%3B%20Flash%20Fill%20or%20press%20Ctrl%20%2B%20E.%3C%2FP%3E%3CP%3EIf%20you%20don't%20know%20Flash%20Fill.%20Check%20it%20out.%20You%20won't%20be%20disappointed.%3C%2FP%3E%3CP%3EIf%20your%20data%20is%20changing%20regularly%20then%20a%20formula%20option%20offered%20by%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F570951%22%20target%3D%22_blank%22%3E%40mtarler%3C%2FA%3E%20is%20better.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1439707%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20text%20from%20different%20cells%20into%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1439707%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687097%22%20target%3D%22_blank%22%3E%40Chris_Hafstein%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIMHO%2C%20the%20solution%20is%20slightly%20depends%20on%20what%20do%20you%20mean%20under%26nbsp%3B%3CSPAN%3E%3CSTRONG%3Emultiple%20cells%3C%2FSTRONG%3E%20(are%20couple%20of%20them%20or%20couple%20hundred%20of%20cells%2C%20sequential%26nbsp%3Bcells%20or%20in%20some%20other%20order)%20and%20what%20means%26nbsp%3B%3CSTRONG%3Ecombine%3C%2FSTRONG%3E%20(with%20delimiter%26nbsp%3Bor%20without%2C%20with%20sorting%20or%20not%2C%20etc).%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EIt's%20always%20better%20to%20provide%20sample%20file%20with%20few%20records%20and%20manually%20entered%20desired%20result.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm trying to combine text from multiple cells into one, but the information in excel help is not working.  How would I accomplish this?

3 Replies
Highlighted

@Chris_Hafstein  there are a few options:

= A1 & B1

= concat (A1, B1)

= concatenate (A1, B1)

= textjoin ("",true,A1, B1)     

Highlighted

@Chris_HafsteinYou could also use Flash Fill. In a cell type what you want the answer to look like. With the cell selected click Data > Flash Fill or press Ctrl + E.

If you don't know Flash Fill. Check it out. You won't be disappointed.

If your data is changing regularly then a formula option offered by @mtarler is better.

Highlighted

@Chris_Hafstein 

IMHO, the solution is slightly depends on what do you mean under multiple cells (are couple of them or couple hundred of cells, sequential cells or in some other order) and what means combine (with delimiter or without, with sorting or not, etc).

It's always better to provide sample file with few records and manually entered desired result.