Hi All,
Is there a formula to join the following characters to create the
example shown below.
B2 C2 D2 (End Result)
JORDAN MIKE JORDAN JORDAN M
I'm getting close with the formula below, but can't work it out.
=LEFT(C1,50)& MID(D1,FIND(" ",D3)+ 1,1)
Thanks,
cRIMSOn
Bookmarks