Forum Discussion
Tiffany_Jo
May 11, 2020Brass Contributor
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? [回答] 癌腫別...
Tiffany_Jo
May 11, 2020Brass Contributor
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.
Alan_Murray
May 11, 2020MVP
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.
- Tiffany_JoMay 11, 2020Brass Contributor
Alan_Murray Thank you.
Users want to replace them by using formulas.
Could you please give me some tips if you know?
- Alan_MurrayMay 11, 2020MVP
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)