Delete the first 4 charcters then Keeping the

Hello,


In excel macro, how can I delete the first 2 characters and THEN keeping the first 5 characters and THEN deleting the rest. The data is in column A and I want the result in column B.

For example: If cell a shows: AXBbing25, after deleting 1st two characters and then keeping the first 5 would giveme Bbing in cell B.

Please help. Thank you in advance.