Quote Originally Posted by mikerickson
=TRIM(LEFT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",255)),255)


by the way, =FIND(" ", A2&" ", 1) will never return an error (unless A2 has an error)
Try the third entry: 8-2719-2-U with my construct!
Edit: Oops! you were explaining a different construct...sorry