Hi all

I need to read a part of a string in one cell and then capture part it and use the bit of info to fill a part of another cell.

Eg

Cell1: (text)GLDQ

then I need to take only the GLD part and place it in another cell in between some more text, like so;

Cell2: =gllinks|Mkt!'(here),ClosePrice'

and I need to do that over about 70 rows each with a different bit of info.

Can anyone help me on how to beging writing a macro on how to do this.