This question is for people who are confident enough to use

This question is for people who are confident enough to use Excel to a high standard.

How do I get the excel doc to filter out everything EXCEPT what\'s circled or boxed-in in the image?

For, ex. on row C417, in column H, I just want the, \"intergenic_variant\" portion of the text, not the whole \"T||||intergenic_variant||||||||\" text

or another example would be  row C436, in column H, I just want the, \"downstream_gene_variant\" NOT the whole \"C|ENSMUSG00000055137|ENSMUST00000068545|Transcript|downstream_gene_variant|||||||4217|-1\" text

basically, I want whats between the keyboard character \"|\" and characters \"|||||||\" (x7 \"|\"s) ....... a.k.a. what i have circled/boxed in the image ofd this post

DBA-1 SNP CHR13 AC306 AT Tel Home Insert Page Layout Formulas Illlintergenic variantlill H2 417 C 228 PASS ic val 418 C 228 PASS c varial 419 G tergenic variant Nllllll 228 PASS 420 C 228 PASS tergenic variant 421 C 228 PASS TIll tergenic variant 422 T 228 PASS CII intergenic variant IINII 423 A 228 PASS intergenic variantl lllllll 424 A 228 PASS intergenic varian lllllll 425 C 228 PASS ntergenic variant 426 T 228 PASS intergenic varian 427A 228 PASS ntergenic variant 428 A 228 PASS intergenic varian 429 G 228 PASS tergenic variant 430T 228 PASS er genic variant 431 T 228 PASS genic varia 432 G 228 PASS nte ic val 433 G pt downstream gene variant 228 PASS TENSMUSG 055137 ENSMU 68545 Tran 434 G pt downstream gene variant 228 PASS TTENSMUSG00000055137 ENSM US 68545 Tran 435 G pt down 228 PASS ATENSMUSG00000055137 ENSMUST 068545 T m gene var 436 228 PASS. ENSMUSG00000055137 ENSMUST00000068545 Transcrip ownstream gene. variant 437 A 228 PASS 38 G 228 PASS 439 A 228 PASS 440 A 228 PASS 441 A 228 PASS 442 C 228 PASS 443 T 139 PASS 444 T 228 PASS 445 A 228 PASS 446 A 228 PASS 447 G 228 PASS TIENSMUSG00000055137IENSMUS 68545 Tran lllllll-1 448 C 227 PASS AIENSMUSG00000055137IENSMUSTO0000068SA5 ITranscriptilntron variant 449 G 228 PASS AIENSMUSG 00000055137 ENSMUST00000068545 ITranscriptilntron variant 450 A 228 PASS TIENSMUSG00000055137IENSMUS 68545 Tra variant IIIIIII-1 451 T 228 PASS CIENSMUSG00000055137IENSMUST00000068545 Transcrip ron variant 452 C 228 PASS AIENSMUSG00000055137 ENSMUST00000068S45lTranscriptilntron variant 453 A G 228 PASS GIENSMUSG00000055137IE NSMUST00000068545ITranscri ron varian 228 PASS 454 G AIENSMUSG00000055137 ENSMUST00000068545 Transcript ilntron variant 228 PASS AIENSMUSG00000055137 ENSMUST00000068545 Transcript ilntron variant 455 G T 228 PASS 456 C TIENSMUSG00000055137IENSMUS 68545 Tran 457 T C 228 PASS CIENSMUSG00000055137 ENSMUST00000068545 Transcriptilntron variant II DBA 1J SNP CHR 13 Search for anything 4917 -1 46521-1 4251 -1 4217 -1 Parker, Christian Douglas 53 41 26 25 47 42 37 33 36 43 42 59 53 53 37 59 31 38 42 57 35 11 47 33 45 36 29 229 AM 240/2017

Solution

To separate sentence from special characters please follow below

Click On DATA tab >then follow the screen shot .Click on Other tick box and put unwanted characters and click on finish