Changes to Concatenate Macro

[mcranda]

http://www.excelforum.com/excel-prog...ate-macro.html


Changes:
Macro breaks if range (rngA) has only 1 line of data
Change concatenate to populate in ,9 instead of ,6
Concatenate eliminate * and - (astricks and dashes)
Change =LEN formula to populate in ,10 instead of ,8
Have number from rngA populate in ,8 without the dash

Please Login or Register  to view this content.

[GC Excel]

Hello,

See if this works:

Please Login or Register  to view this content.