I have the following on a1 and a2
Leather
Clothes Gents
I want results on b1 and b2
Leather
Clothes
I have the following on a1 and a2
Leather
Clothes Gents
I want results on b1 and b2
Leather
Clothes
Try
=LEFT(A1,FIND(" ",A1&" ")-1)
Jonmo1 thanks , works
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks