Copy one cell and merge into another
Hi,
Is a macro for this possible?
1. Active cell (is a number)
2. 4 cells to the right from active cell (is text)
3. Add the value from the first cell (1) at the end of the text without any
space
Example
Before macro:
First active cell = any number e.g. 458
Four cells to the right = Test/
After macro:
First active cell = 458
Four cells to the right = Test/458 (if possible change 458 to blue colour.
Kaj Pedersen
|