Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1266204%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1266204%22%20slang%3D%22en-US%22%3EHello%2C%20I%20was%20wondering%20is%20there%20a%20shortcut%20that%20allows%20me%20to%20extract%20a%20certain%20number%20combination%20like%20(01011).%20Where%20each%20element%20is%20in%20a%20different%20column%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1266204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1266234%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1266234%22%20slang%3D%22en-US%22%3EYes..%20You%20can%20use%20Flash%20Fill...%20If%20you%20can%20upload%20a%20sample%20data%2C%20I%20can%20show%20you%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1266244%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1266244%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BThank%20you%20for%20responding!%20This%20is%20an%20example%20of%20what%20i'm%20working%20on.%20I'm%20trying%20to%20extract%20the%20number%20combination%20(1%200%200%201%201%201%20)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hello, I was wondering is there a shortcut that allows me to extract a certain number combination like (01011). Where each element is in a different column?
2 Replies
Highlighted
Yes.. You can use Flash Fill... If you can upload a sample data, I can show you
Highlighted

@Abiola1 Thank you for responding! This is an example of what i'm working on. I'm trying to extract the number combination (1 0 0 1 1 1 )