Excel Get Right Word | Get Left Word - DAK Networks

Details: Created: 13 October 2021

Excel Get Right Word | Get Left Word

=TRIM(RIGHT(SUBSTITUTE(text," ",REPT(" ",100)),100))
=LEFT(a1,FIND(" ",a1)-1)