Forum Discussion
How to remove the sentences from Excel
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.
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.
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.
Alan_Murray Thank you.
Users want to replace them by using formulas.
Could you please give me some tips if you know?
