i need to edit several cells at a time, i know i can change/replace info with
the replace function.

But what if all the cells contain diferent info but the first word is common
and i want to keep only the first word.

ie.

EDP Spray - only 14 left
EDP Spray - only 4 left
EDT Spray - only 2 left


i Want to erase from the - forward just to sat

EDP
EDP
EDT

etc...