• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 242
  • Last Modified:

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?
  • 2
2 Solutions
Steven HarrisPresidentCommented:
Your formula is expressly set to find the space and only use the First Name.

Any reason why you can't use the following?

I don't what you want as result. if you want to combine two cells you can use
=B2&" "&C2
or if you want to remove extra spaces between B2 and C2 you can use
=trim(B2)&" "&trim(C2)

seems your formula just combine two texts.
Steven HarrisPresidentCommented:
Can you provide an example of what the cells look like now, both B2 and C2, and then what you want as the output?
mig1980Author Commented:
Old question. Answer no longer needed.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now