Excel formula, textjoin, delimiter

%3CLINGO-SUB%20id%3D%22lingo-sub-2367069%22%20slang%3D%22en-US%22%3EExcel%20formula%2C%20textjoin%2C%20delimiter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367069%22%20slang%3D%22en-US%22%3EAlright%20so%20I%20want%20my%20spreadsheet%20to%20pull%20up%20all%20instances%20of%20a%20pokemon%20type%20in%20one%20search%2C%20and%20put%20each%20result%20on%20its%20own%20row.%3CBR%20%2F%3ESo%20I%20look%20through%20the%20Kanto%20pokedex%2C%20I%20set%20up%20all%20the%20Pokemon%20with%20their%20types%2C%20and%20suceed%20to%20get%20it%20to%20show%20all%20water%20types%20using%20a%20textjoin%20formula%2C%20but%20I%20can%20not%20find%20a%20way%20to%20control%20the%20wrapping%20when%20I%20merge%20cells%20to%20cover%20the%20issue%20of%2030%20or%2040%20instances.%3CBR%20%2F%3EDelimiter%20says%20hard%20enter%20is%20an%20option%2C%20but%20I%20have%20not%20found%20a%20way%20to%20make%20it%20happen.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2367069%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor
Alright so I want my spreadsheet to pull up all instances of a pokemon type in one search, and put each result on its own row.
So I look through the Kanto pokedex, I set up all the Pokemon with their types, and suceed to get it to show all water types using a textjoin formula, but I can not find a way to control the wrapping when I merge cells to cover the issue of 30 or 40 instances.
Delimiter says hard enter is an option, but I have not found a way to make it happen.
1 Reply
Alright so my answer was char(10)