help with excel formula

Question

excel

I have an online store, I fill it with data via CSV import
. I need to sort the products alphabetically.

There is cell D, where the names go
AND cell F, where there should be a category, for example, "Spare parts - A", "Spare parts - G", etc.

Those. in F you need to enter “Spare parts - [first letter of cell D]”, what formula do you need to do?

Answer 1

dl.dropbox.com/u/916366/habr/qa_excel.png - 3 minutes of googling.