hi R.Karunanith,
You can simply use the concatenate function to do the concatenation i have
tried doing it seems to work fine for me, hope this solution works for you,
i just tried helping, it it does'nt work please forgive me.
Thanks & Regards
Amit Basra
On Wed, Apr 24, 2013 at 10:42 PM, karu
Sirs,
I want to fill down Sim card numbers around 5 lacs each contain 19 digits
and the sims have numbers from one value to another, in sequence for 5 to
10,000.
I split this to 3 or 4 columns and then idea to concatenate. The numbers in
sequence
is highlighted in yellow.Using a macro i can m