Concatenate when pasting.

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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top