if you look at Column J of the attached file you can see it is picking up tax Credit from Column A (13.88 ETC)
I need this formula to be changed to pick up gross (one row up in ColA)
In K you can see it is picking up the holdings from ColA.
The ones i have highlighted re are incorrect because they dont pick up enough characters, so the formula needs to be adjusted to pick up numbers that would be a over 8 figures
If anyone can adjust for these two that would be great!