Hello,
I need to extract multiple 5-digit numbers from a cell that contains both letters and numbers. I found a thread that solves for how to extract a single number but this doesn't work for me because my data might contain multiple 5-digit numbers.
Here is an example of how my data looks (column A). I would like to extract the 5-digit numbers to column B.
I would like to have the 5-digit numbers in the same cell, separated by commas. Also, the data might contain numbers that are more or less than 5 digits - these should be ignored.
Thank you!
<tbody>
</tbody>
I need to extract multiple 5-digit numbers from a cell that contains both letters and numbers. I found a thread that solves for how to extract a single number but this doesn't work for me because my data might contain multiple 5-digit numbers.
Here is an example of how my data looks (column A). I would like to extract the 5-digit numbers to column B.
I would like to have the 5-digit numbers in the same cell, separated by commas. Also, the data might contain numbers that are more or less than 5 digits - these should be ignored.
Thank you!
Column A | Column B | |
1 | One number is 12345. And a second number is 54321. | 12345, 54321 |
2 | There is just 1 five digit number: 73638 | 73638 |
3 | There is 1 five digit number (00293) but also 1 six digit number (038822), which should be ignored. Numbers might have leading zeros. | 00293 |
4 | 12345, 54321, and 55555.....but not ABC123 or 123ABC. | 12345, 54321, 55555 |
<tbody>
</tbody>