Write a macro
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
|