Do you actually get "---" in the data?

It looks as if for every "proper" number you have a decimal point.
What happens if one of the numbers is an integer? Do you get 4.00 or
4 ?

How many different text items do you get? If you only have a limited
number (as I suspect), then you could set up a table like this:

iShares S&P 500 Index IVV ABC
iShares S&P Global 100 Index IOO ABD
iShares MSCI EAFE Index EFA ABE
iShares Lehman Aggregate Bond AGG ABF
and so on ...

and then you could use Find & Replace within a macro (or SUBSTITUTE in
a formula) to change your text values to some three letter code plus a
space, and then do Data | Text-to-columns on what remains, using
<space as the delimiter.

Then you could convert the 3-letter codes back to text again using
INDEX/MATCH.

Hope this helps.

Pete


On Feb 1, 5:36*pm, ORLANDO V
wrote:
Any ideas on how to do a text to columns on sample data below? *The only
thing somewhat static is the fact that each row has seven numbers starting
from the right working left. *(where "---" equals blank or zero.)
I appreciate any help given?

iShares S&P 500 Index IVV (6.27) (10.86) (6.27) (2.70) 7.07 11.78 ---
iShares S&P Global 100 Index IOO (8.68) (12.15) (8.68) 0.51 9.03 13.47 ---
iShares MSCI EAFE Index EFA (7.85) (13.82) (7.85) (0.05) 13.78 20.22 ---
iShares Lehman Aggregate Bond AGG 2.31 4.15 2.31 9.59 4.88 --- ---