Excel Get Right Word | Get Left Word
=TRIM(RIGHT(SUBSTITUTE(text," ",REPT(" ",100)),100))
=LEFT(a1,FIND(" ",a1)-1)
Excel Get Right Word | Get Left Word
=TRIM(RIGHT(SUBSTITUTE(text," ",REPT(" ",100)),100))
=LEFT(a1,FIND(" ",a1)-1)
We are not taking on new clients at this time.