Hello Everyone,

I have only one column A with thousands of rows like following (with different length and text): My required output is available in column B and on-wards

<tbody>

</tbody>

I need a formula/vba code that will start reading from left most character of the cell in column A and check if its between 1 to 9, if it is then check if it is just a five digit number, if it is then put it into column B and then look for another 5 digit number in the same cell and upon finding any other 5 digit number put in other columns. Please also keep in consideration that the five digits number that I am looking for cannot start with zero at all. If some number is starting with zero and its five digit then ignore. Please also keep in consideration that it cannot be started with # sign. 5 digit numbers are started with any alphabet character or with space or with these special characters &/-

5 digit number can also be started with nothing. I mean if the cell itself is starting from a 5 digit number

Thanks,

Imran.

I have only one column A with thousands of rows like following (with different length and text): My required output is available in column B and on-wards

Column A | Column B | Column C | Column D | Column E | Column E |

11101&11051 INV#29596 | 11101 | 11051 | |||

GV65245/98765&67543 06978 rh#05234 54765 | 65245 | 98765 | 67543 | 54765 | |

BKO-7975/7893/8013/7878/07946/8094/806 | |||||

FR-7470/7424/7472/-FR-7503/7348/ 7433/73445 | 73445 | ||||

7530/ DXW/76170/7624 INV#E66104 | 76170 |

<tbody>

</tbody>

I need a formula/vba code that will start reading from left most character of the cell in column A and check if its between 1 to 9, if it is then check if it is just a five digit number, if it is then put it into column B and then look for another 5 digit number in the same cell and upon finding any other 5 digit number put in other columns. Please also keep in consideration that the five digits number that I am looking for cannot start with zero at all. If some number is starting with zero and its five digit then ignore. Please also keep in consideration that it cannot be started with # sign. 5 digit numbers are started with any alphabet character or with space or with these special characters &/-

5 digit number can also be started with nothing. I mean if the cell itself is starting from a 5 digit number

Thanks,

Imran.

Last edited: