Excel fomula concatenate to text

  johnincrete 16:15 09 Nov 2009
Locked

I have columns for first name & last name. I have used =CONCATENATE(B17,C17)to create a fullname column.
How do I get a space between the first and last name.
e.g. first name FRED last name BLOGGS gives me FREDBLOGGS & I need FRED BLOGGS.

  MAJ 16:24 09 Nov 2009

=CONCATENATE(B17," ",C17)

  johnincrete 03:41 10 Nov 2009

So easy when you know how!
I tried something similar and made a right mess - not sure how - hence the post.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?