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

Change a great number of words in word files, with a macro as short as possible. 5
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Format column widths from one table to a separate table on same page 1
How can the font and size of (all) citation numbers be altered? 1
Two lines in one in one line - How to do 2
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Prompt For Replace in Selection And More... 0
How to open multiple instances of Word 365? 5

Top