Link to home
Start Free TrialLog in
Avatar of mig1980
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?
ASKER CERTIFIED SOLUTION
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Can you provide an example of what the cells look like now, both B2 and C2, and then what you want as the output?
Avatar of mig1980
mig1980

ASKER

Old question. Answer no longer needed.