Hi Champs,
I have values in A1,B1,C1 and i need a macro to concatenate these in D1 as (valueof A1-valueof B1-valueof C1-00000-00000) .
Please note: I need the hyphen in between values and 00000 at last. I have attached the sample for the reference.
Thanks for the help in advance.
Bookmarks