#VALUE!

[Rubber Beaked Woodpecker]

Hi this formula work very well if there are more than one word in cell in N4. However if there is only one word in N4 I get the error #VALUE!
How can I change the formula to return the one word rather than the error?

=(BF4)&" "&LEFT(N4,FIND(" ",N4)-1)

Thank you
RBW

 

[Fluff]

How about

=BF4&" "&LEFT(N4,FIND(" ",N4&" ")-1)

 

[Rubber Beaked Woodpecker]

How about

=BF4&" "&LEFT(N4,FIND(" ",N4&" ")-1)

Brilliant! and thanks for the very fast reply thank you

 

[Fluff]

You're welcome & thanks for the feedback.