How to Delete Everything Before a Specific Character
To remove everything before a specific character in Excel you can use the below formula:
=RIGHT(cell,LEN(cell)- SEARCH(“char”, cell))
In the above formula, we have used the SEARCH function to determine the position of the target character within the text in the cell. This position is subtracted from the total length of the string obtained through the LEN Function. The resulting difference is then passed as an argument to the RIGHT Function, which will extract characters from the end of the string.
The SEARCH Function is not case-sensitive which means it does not differentiate between upper-case and lower-case characters. If you want to distinguish between letter cases, you can use the FIND Function instead of SEARCH Function.
For example
=RIGHT(B2, LEN(B2) – SEARCH(” , ” , A2))
In this case, the comma is after a space character. To remove leading spaces in Excel, we can wrap the core formula in the TRIM Function.
=TRIM(RIGHT(cell, LEN(cell)- SEARCH(” , ” , cell)))
How to Remove Text Before or After a Specific Character in Excel
Do you need to clean up your data in Excel by removing text before or after a specific character? This common task can help you organize your information and make your spreadsheets more manageable. In this article, you will learn the simple steps to remove text before or after a specific character in Excel. With these easy methods, you can quickly tidy up your data and make your work more efficient.
Let’s see how to remove the text before and after a specific character or text string in Excel.
Contact Us