Vlookup & Concatenate?
On 29/07/2007 13:12:00, JLatham wrote:
Don't make it any more complex than needed, try this
=IF(ISERR(LEFT(A2,FIND(" ",A2)-1)),A2,LEFT(A2,FIND(" ",A2)-1))
instead of the plain
=LEFT(A2,FIND(" ",A2)-1) formula. That will display single words, or 1st
word of multiple word entries.
I''l try this later. Got to go out for a couple of hours.
Thanks again.
|