Hit the Enter key to accept the suggestion.Once Excel feels the pattern in the values you are entering, it will display a preview for the remaining cells following the same pattern. Start typing an appropriate value in the next cell.In a cell next to the first cell with your data, type the expected result and press Enter.In modern versions of Excel (2013 and later), there is one more easy way to eradicate text that precedes or follows a specific character - the Flash Fill feature. If you'd rather have the names and phone numbers separated by a comma, then type a comma (,) in the Replace with field. To delete text between two commas, use an asterisk surrounded by commas (,*,). If your data is separated by commas without spaces, then use an asterisk followed by a comma (*,). Please notice that we are replacing not just a comma but a comma and a space to prevent leading spaces in the results. To delete a substring before a comma, type an asterisk, a comma, and a space (*, ) in the Find what box. To delete a substring between two characters, type an asterisk surrounded by 2 characters (char*char).įor example, to remove everything after a comma including the comma itself, put a comma and an asterisk sign (,*) in the Find what box, and you'll get the following result:.To remove text after a certain character, type the character followed by an asterisk (char*).To eliminate text before a given character, type the character preceded by an asterisk (*char).In the Find what box, enter one of the following combinations:.Press Ctrl + H to open the Find and Replace dialog.Select all the cells where you want to delete text.To remove part of a string preceding or following a specific character, these are the steps to perform: Custom function to remove text on either side of a characterĭelete text before, after or between 2 characters with Find & Replaceįor data manipulations in multiple cells, Find and Replace is the right tool.Remove everything before the last occurrence of a character.Remove everything after the last occurrence of a character.

Strip text before Nth occurrence of a character.Strip text after Nth occurrence of a character.Today, we'll investigate one more use case - how to delete everything before or after a specific character.

In the recent couple of articles, we've looked at different ways to remove characters from strings in Excel.

Text spammer between a certain time