How to change this formula?

|————— |———————-|
|Given Names| First Given Name  |
|————— |———————-|
|John George  | John                          |
|————— |———————-|
|Raghu              | #VALUE!                  |
|————— |———————-|
|Mary Jane      | Mary                         |
|————— |———————-|
|Eddy Teddy    | Eddy                          |
|————— |———————-|

=LEFT(A2,FIND(” “,A2)-1) is working for all records with more than one given name.

How do I include an if statement?




Expert Asked on August 6, 2018 in Excel: Forumlas.
Add Comment
1 Answer(s)

Try this instead

=IFERROR(LEFT(B1,FIND(” “,B1)-1),B1)

RE: How to change this formula?

Expert Answered on August 9, 2018.



on August 9, 2018.
Add Comment
  • Found this useful?

    Please share using the share button above.

    If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.

    Found the answer useful and wants to credit the user, then vote the answer (vote up).

  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.