Data Copy with a special charater added in

[aviatecar]

Hi Gurus:

So I am trying to copy data from 3 different cells into a single cell and add an "@" in between( please see attachment for illustation).
I am wondering if anyone can write me a code for this task.


Many many thanks,

Chris

[StevenM]

Backup your data.
Copy the code below to a standard module.
Run: ConcatenationAatBC

Please Login or Register  to view this content.

[aviatecar]

Dear Steven:

I really apprecaite your help. The code did exactly what I want it to do!

I need 2 more similer code to get my job done, would you take a look of these 2 threads as well?!

http://www.excelforum.com/excel-prog...html?p=2857860
http://www.excelforum.com/excel-prog...html?p=2857865

Thanks Steve,

Chris