J
JJ
Excel 2007
Concatenate when pasting.
Instead of replacing the destination cell when pasting copied data I want Excel to concatenate the copied cell with the destination cell and add the “/”-character in between.
Example:
A1:1
A2:2
A3:3
B1:4
B2:5
B3:6
If A1:A3 is copied and B1 is selected and the macro is run. I want the result to look like this:
B1:1/4
B2:2/5
B3:3/6
If B2 is blank the result in B2 should be “2”, not “/2”
The macro should be able to handle large ranges not just one column.
Thanks for helping me out
Concatenate when pasting.
Instead of replacing the destination cell when pasting copied data I want Excel to concatenate the copied cell with the destination cell and add the “/”-character in between.
Example:
A1:1
A2:2
A3:3
B1:4
B2:5
B3:6
If A1:A3 is copied and B1 is selected and the macro is run. I want the result to look like this:
B1:1/4
B2:2/5
B3:3/6
If B2 is blank the result in B2 should be “2”, not “/2”
The macro should be able to handle large ranges not just one column.
Thanks for helping me out