I have a column with similar cells but spacing around the colon varies.
<tbody>
</tbody>
FOr one formula, I want to find ID1, then extract the number 52685 which I have the following:
=MID($A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$A2&"0123456789")),5)
How do I conduct it if it's 6 characters?
The other formula, I want to find ID4, and extract number 84814
ID1: 52685 ID2: 83145 ID3: 52973 ID4: 84814 Name: Kevin |
<tbody>
</tbody>
FOr one formula, I want to find ID1, then extract the number 52685 which I have the following:
=MID($A2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$A2&"0123456789")),5)
How do I conduct it if it's 6 characters?
The other formula, I want to find ID4, and extract number 84814
Last edited: