View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Text entered in two separate cells appear as one word in another

Hi,
=A1&B1

if you need a comma in between

=A1&","&B1

if this helps please click yes, thanks

"lizzie" wrote:

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