I want to match this string: [nnnn]*, nnnn is a number held in cell A5 so I would use match like this:
This returns 20 correctly.
I can’t work out how to replace this “*” so that the number, in this case 1301, is obtained from cell A5.
Can you help? Thank you.