Now yahoo supports most of NSE Symbol as NSE bhavcopy symbols +.NS (Not All)
Easy way to make it is Open New Excell Sheet Copy Bhavcopy Symbol and Paste it on Column A Write .NS to column B and in Column C1 write A1&B1 so you will get combined in column C and drag it for all.
i.e
A B C
1 RELIANCE .NS RELIANCE.NS
Copy These symbol and Paste Special and Value any where you want
Easy way to make it is Open New Excell Sheet Copy Bhavcopy Symbol and Paste it on Column A Write .NS to column B and in Column C1 write A1&B1 so you will get combined in column C and drag it for all.
i.e
A B C
1 RELIANCE .NS RELIANCE.NS
Copy These symbol and Paste Special and Value any where you want