Help needed..

A

Angus

I have an excel spreadsheet... I need to merge two cells
together and keep the data in both (ie in the same cell)...

can it be done???

cheers... Angus...
 
T

tettrick

Hi Angus,

Try the "concatenate" function. It works similarly to the "sum
function, except it combines strings of text from different cells.
Keep in mind that you'll need to add spaces between text if your cell
with text don't already have spaces at the end of each word. You ca
easily do this by adding to your spreadsheet a cell that has a singl
space in it. Then include that cell between each of the words you us
in the concatenate function. See the JPEG for an illustration of thi
function.

Hope this helps!
tettric

Attachment filename: concatenate function in excel.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=69445
 
T

tettrick

...PS -

Although the spreadsheet will show your combined cells as you want, th
spreadsheet will treat it as a formula. If you want to use the word o
# that your two cells combine to create, just copy the concatenate
cell, then use "Edit" on your commands menu and follow the path:

paste special
values

This will give you just the text, and you can use it however you want.

Good luck!
tettric
 
Top