I have the following sample data in column "A".

I've only shown 8 rows worth of data which could increase to 3000+, what I want to do is extract the last 4 digits into Column "B" only for the data shown

T/PR/T3B/01PA |

T/PR/T3B/01PA |

T/PR/T3B/01PA |

T/PR/T3B/01PA |

T/PR/T3B/01PA |

T/PR/T3B/01PB |

T/PR/T3B/01PB |

T/PR/T3B/01PB |

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>

</tbody>

This is part of a larger VBA exercise and this is the stumbling block.

As you may have guessed I am a complete novice at VBA so any help would be much appreciated.

Thanks in advance.

Bill.