May 10 2020 05:59 PM
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?
[回答]
癌腫別のMSI-high固形癌の割合の図のデータはペムブロリズマブの適応になる患者がどれくらいいるのか予測するために調査した文献の補助的なデータであり、解析が行われた癌腫毎の症例の母数や、詳細な解析方法についての記載は文献中(1)にありません。この論文のグラフは各癌腫におけるMSI-High患者の割合の参考データとしてご参照ください。
<引用>
(1)PMID: 28596308: Le DT, et al. Science. 2017; 357: 409-413.
May 10 2020 10:36 PM
@Tiffany_JoIf the sentences you want to remove all begin with the same text - (1)PMID, then you could use Text to Columns on the Data tab to split the cell at that point. At then delete the new column created.
You could also use Find and Replace to remove the content with that starting place using the wildcard characters - (1)PMID*
Excel formulas can only return values and not delete content. So a formula approach would only create a good cell. Not correct the original.
May 10 2020 10:51 PM
Hi Thank you.
If I would like to use the Find and Replace, could you please kindly tell how to judge the length of the sentence which starts with PMID. I think the lengths are different.
May 10 2020 11:01 PM
@Tiffany_JoNo need. select the column, press Ctrl + H for Replace. Then use PMID* in the Find what and nothing in the Replace.
The * is a wildcard character and will replace any text regardless of length after PMID.
May 11 2020 01:14 AM
@Alan Murray Thank you.
Users want to replace them by using formulas.
Could you please give me some tips if you know?
May 11 2020 01:51 AM
@Tiffany_JoSure. You can pull all of the sentence up to the PMID with a combination of the LEFT and FIND functions.
=LEFT(A1,FIND("PMID",A1)-1)
Feb 21 2021 02:33 AM
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","")
Feb 21 2021 09:15 AM
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: