Hi!
Assume you want to combine cells A1:A100 with cells
B1:B100. In cell C1 enter this formula:
=A1&B1
If you want a space between values:
=A1&" "&B1
Drag copy down to C100 or just double click the fill
handle.
Now, if you no longer need the data in columns A and B
select C1:C100 and do Copy/Paste Special/Values and then
either delete columns A and B altogether or just delete
the range A1:B100.
Biff
-----Original Message-----
I want to copy the contents of a cell and insert it at
the beginning of the
text of another cell: ie I want to combine the text
contained in two cells
into one cell. I can do it manually but would like to
use a macro as I have
a lot of cutting and inserting to do!!
I use Office 2000.
.
|