Text entered in two separate cells appear as one word in another

  • Thread starter Thread starter lizzie
  • Start date Start date
L

lizzie

Text entered in two separate cells eg. A1 TOM B1 HARRIS how do I get these
two words to appear as TOMHARRIS in Cell C1
 
Hi,
=A1&B1

if you need a comma in between

=A1&","&B1

if this helps please click yes, thanks
 
Back
Top