How do I separate the Fund Name, Ticker and Net Flows in this list, which are currently in one column, into three separate columns with Excel 2003? I got it from this site, ETF Fund Flows Tool - IndexUniverse.com, and wanted to reproduce it for a newspaper publication.
I couldn't find an answer to this because the fund names have varying number of words while the tickers have three or four letters and the fund flows have five or six numbers, commas and no commas.
<tbody>
</tbody>
Any help would be greatly appreciated!
I couldn't find an answer to this because the fund names have varying number of words while the tickers have three or four letters and the fund flows have five or six numbers, commas and no commas.
Flows for 09/09/2013 - 09/13/2013 Top 10 Creations Fund Name Ticker Net Flows Details SPDR S&P 500 iShares MSCI Emerging Markets iShares Russell 2000 PowerShares QQQ Market Vectors Gold Miners Industrial Select SPDR iShares MSCI Brazil Capped iShares Core S&P 500 Vanguard FTSE Emerging Markets iShares Floating Rate Bond | ||
<tbody>
</tbody>
Any help would be greatly appreciated!