Forum Discussion

Tiffany_Jo's avatar
Tiffany_Jo
Brass Contributor
May 11, 2020

How to remove the sentences from Excel

hi all   There is a long text in the Excel cell. I would like to remove the sentence with the starting "PMID: ". Which formula I could use to remove the sentence highlighted in red?   ［回答］ 癌腫別...
excel
Formulas and Functions
naimbic's avatar
naimbic
Copper Contributor
Feb 21, 2021

Tiffany_Jo 

 

 

try these...

 

=SUBSTITUTE(P8,"Plus d'informations","")

=SUBSTITUTE(SUBSTITUTE(P9,"text-to-delete-1",""),"text-to-delete-2","")
=SUBSTITUTE(P8,"text-to-delete","")

=SUBSTITUTE(SUBSTITUTE(P9,"text-to-delete-1",""),"text-to-delete-2","")
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Feb 21, 2021

    naimbic 

    That doesn't work. The task is for the data like

    abasdas as asd das 
PLUS: fdd;as dasdkas;d
,.dad.,f;dfe;;ee;
s;dlflsdfl; as;df;
PLUS: a;s; as;dlmas
===============
ssssssssssssss

    remove all lines which start from PLUS:

Resources