Is it possible to write macro which will replace text in cells.
For example: In cell A1 is this kind of text (link): =+'[Gal Birch 1200 1400 1500 P1 R4_1.xlsx]1500 Birch Gal'!$H$19
With macro I would like change cell A2 this kind of link: =+'[Gal Birch P1 R4_1.xlsx]1400 Birch Gal'!$H$19...