Spacing within excel code

[DawginAuburn]

I am trying to allow a space in the following command, but it keeps putting the words together with no space. Anyone have any ideas? Thanks!


the command =B4&B5

Keeps showing up as JohnWilson, once I hit enter.

I want it to show up as John Wilson, notice the space. Spacing the "B4" and "&" do nothing.





Thanks a lot!

[alansidman]

Try this:
=b4&" "&B5

Make sure you put a space between the two quotation marks.