Merge Text From Two Cells

  • Thread starter Thread starter Salza
  • Start date Start date
S

Salza

I would like to merge texts from two different cells into the third cell.

Example:-
Cell A1 - Tom
Cell A2 - Jones
Cell A3 - Tom Jones

I am using this formula in cell A3 :-

=A1&""&B1

But I get TomJones (combined into one word) instead of Tom Jones (two
words).
Can someone help me to modify the code/formula so that I get Tom Jones (two
words)


Warmest regards,
Salza
 
Hi Salza!

Use:

=A1&" "&B1

Note the space between the double quotation marks

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top