How to erase a word up to a certain character in Excel?

Question

excel

I have a list of categories in Excel.

They are written like this: "Category name > subcategory name > subcategory name > product name"

I need to erase the product name in all lines (there are about 9200 of them). Is there a way to delete the product name?

Answer 1

Attach a screenshot of the file.
If all the names are in one cell (CSV) and they are separated by a ">" sign, then you can use Text To Column . Divide the data into columns, and then, if necessary, join them with the =CONCATENATE() formula.

Answer 2

Add a screen.
If ">" is a directly used separator, and all lines are formed in the same way, then there are options:
1. Copy the column, use the regular Excel text to column, delete the column with the names of the goods, connect back with a formula.
2. You can write a formula that determines the position of the nth separator character in the string, in your example, the third ">", and leaves the beginning of the string before this character, and to the right - discarding.
Find the nth occurrence of a character - https://www.google.com/search?q=excel+vba+find+nth...
Further banal LEFT
3. Generally it is better to store all data in separate columns. Separate categories, separate subcategories, etc. Then it is much more convenient to work with them, you can use autofilters, combine / process as you like.

Answer 3

CTRL + F on the "Replace" tab