mig1980
asked on
Excel formula not pulling correctly
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.
Any ideas?
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.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can you provide an example of what the cells look like now, both B2 and C2, and then what you want as the output?
ASKER
Old question. Answer no longer needed.