Makes a lot of sense! I will try it. Thank you!


"HKaplan" wrote:

If this comes from the Internet, you might try a web query to import
it, rather than copy & paste (if that's what you did).

Data | Import External Data | New Web Query

See if that brings it in somewhat better parsed.

Otherwise, if the funds are consistent (i.e. always S&P 500 Index IVV,
S&P Global 100 Index IOO, etc.) then you could create a table with
just that piece of the string, one entry for each account. Easy to
first remove the IShares text, which leaves you with the fund info.

Then use a formula something like this to strip out the fund from the
string:
=RIGHT(C2,LEN(C2)-LEN(A1)+1). Where A1 contains the fund name and C2
is your string (without the IShares text)

This formula would return something like (8.68) (12.15) (8.68) 0.51
9.03 13.47 0.

Then you have 7 numbers separated by spaces. Easy to convert to
columns.

So column 1 would contain the fund name. Columns 2-8 would be your
numbers.

You would need a lookup first to match the fund to the string, but
that's easy.

Does that make sense.