Home

INDEX MATCH with cells with Line Breaks

%3CLINGO-SUB%20id%3D%22lingo-sub-583103%22%20slang%3D%22en-US%22%3EINDEX%20MATCH%20with%20cells%20with%20Line%20Breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583103%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWondering%20if%20there%20is%20a%20way%20to%20use%20INDEX%20MATCH%20(or%20another%20Excel%20function)%20that%20can%20return%20lines%20of%20text%20from%20cells%20separated%20by%20line%20breaks%20(Alt%20%2B%20Enter)%20and%20have%20specific%20lines%20of%20text%20from%20the%20INDEX%20cell%20separated%20into%20different%20cells%20in%20the%20same%20column%20on%20a%20different%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-583103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642523%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20MATCH%20with%20cells%20with%20Line%20Breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642523%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3Bpage%20not%20found%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-612626%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20MATCH%20with%20cells%20with%20Line%20Breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-612626%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344046%22%20target%3D%22_blank%22%3E%40Super765%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsfmagazine.com%2Fpost-entry%2Fnovember-2017-excel-split-delimited-data-into-new-rows%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EThat%20would%20be%20job%20for%20PQ.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-642734%22%20slang%3D%22en-US%22%3ERe%3A%20INDEX%20MATCH%20with%20cells%20with%20Line%20Breaks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-642734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344046%22%20target%3D%22_blank%22%3E%40Super765%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20edited%20my%20post.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super765
New Contributor

Hello All,

 

Wondering if there is a way to use INDEX MATCH (or another Excel function) that can return lines of text from cells separated by line breaks (Alt + Enter) and have specific lines of text from the INDEX cell separated into different cells in the same column on a different sheet.

3 Replies

@Detlef Lewin page not found

@Super765 

I edited my post.