Why don't you just use a worksheet formula concatenation.
You will have the same number of used cells either way from your description.
If you want a macro you will need to be more specific as to what you need
"another cell" just does not carry much meaning. Is it one cell at the top,
on another sheet; or is does the cell change for each row and is found in
a particular column.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"dasmithjones" wrote in message ...
write macro that copies any numbers in a cell & appends those numbers
proceeded by a "." to the contents of another cell, same row?
example:
r1c1 r1c2
Boxholder PO Boxholder 123
the macro would copie the number value of r1c2 (123) and append the contents
of r1c1 preceded by a period.
Results desired:
Boxholder.123 PO Boxholder 123
Macro would have a control+c shortcut and would execute only once for the
selected row.
Thanks,
--
DASJ