Excel formula not pulling correctly
Posted on 2013-10-25
Good day everyone. I have a formula that compares a few cells together. The problem is that The comparison of one cell only compares until a space and does not pull anything after that.
Here is the formula:
=IF(IFERROR(Find(" ",B2),1)>1,LEFT(B2,FIND(" ",B2))&" "&C2, B2&" " &C2)
B2 cell contains first and middle name of user, C2 contains last name of user. With the formula above, it only pulls the value until the space. I want it to pull the whole cell.