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.
Bookmarks