How to merge 2 + contiguous cells without lossing data?

P

Patti

I need to merge two or more contiguous cells without lossing the data.

Also I have cells that I copied & pasted into cells and I am unable to add
data to these cells.
 
J

John

Hi Patti
To concatenate two cells, it can be done this way :
=A1&B1 this will merge A1 with B1.
If you want space between words; =A1&" "&B1
You can concatenate has many cells as you like, or had words like this =A1&"
"&B1&" "&Last Word"
HTH
John
 
J

John

Correction to the last example, missing double quote
=A1&" "&B1&" "&"Last Word"
John
 

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

Top