I need anything that looks like a whole number in a different cell. I should've gave examples of how it should be:

Column A
M RTG 1525; MY HGR-P-T 100042; RPT 100721


Column B 1525

Column C 100042

Column D 100721