I am trying to filter a column by copying only first word from a column using LEFT function. The thing is if I use:
=Left(A1,Find(" ",A1)-1)
I can copy only cells that have space separation, my sheet contains cells of different criteria: space, comma and some cells already are just one word, I need to copy whatever format is to a new column. Thanks
Bookmarks