TB's Code Library
It's all about the code...
Thursday, May 26, 2005
Excel code to grab the first word in a referring cell
In this caseâ€¦Cell, T4, has the value in it you want.
=IF(LEN(T4)=0,"",IF(ISERR(FIND(" ",T4)),T4,LEFT(T4,FIND(" ",T4)-2)))
Share to Twitter
Share to Facebook
Share to Pinterest