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

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
 
E

Eduardo

Hi,
=A1&B1

if you need a comma in between

=A1&","&B1

if this helps please click yes, thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extracting times 2
Excel Typed text appears in wrong cell 0
cell value plus text 3
Excel formula for seperating two words in the same cell. 2
cells with one to multiple lines 1
Cells with varying number of lines 1
Excel 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1

Top