Combining data in cells with with a space

  • Thread starter Thread starter elfeste
  • Start date Start date
E

elfeste

I am trying to combine a first and last name from a table for use in
report.

First name John
Last name Doe

I need the report to display John Doe with the space in between
What I get is JohnDoe

I am using the expression =[FirstName] & [LastName] to produce th
result in the report.

Does anyone know what I need to do to display the name with the space?

Thank
 
FirstName & " " & LastName

elfeste said:
I am trying to combine a first and last name from a table for use in a
report.

First name John
Last name Doe

I need the report to display John Doe with the space in between
What I get is JohnDoe

I am using the expression =[FirstName] & [LastName] to produce the
result in the report.

Does anyone know what I need to do to display the name with the space?

Thanks
Click to expand...
 
Back
Top