excel - Get distinct values for a string in a cell -


i have spreadsheet looks that:

enter image description here

i want distinct sections, in fact distinct first string section colume. tried advanced filters however, gives me whole string. there excel formula check columes first string?(like here: bla, blub, bla1, bla2, blue)

i appreciate answer!

in excel, add new column with:

=left(b2,find(" ",b2)) 

that give list of first words; after can use filters.


Comments