HI,
I have text strings of a variable length that contain a number i want to extract. The number will follow either, F. F. (space at the end) or Sans
the number will vary in length and then will be followed by a space or another letter.
examples
<colgroup><col><col></colgroup><tbody>
</tbody>
Can you advise of a macro to extract this? i have tried various formula combinations, arrays using a name range of the variables, but i cannot get it to consistently work.
Thank you in advance
I have text strings of a variable length that contain a number i want to extract. The number will follow either, F. F. (space at the end) or Sans
the number will vary in length and then will be followed by a space or another letter.
examples
Text String | Number |
lif(55)n.123 fr | 123 |
lif(5500)n. 567 (home) | 567 |
efg(2200)S.8910 May | 8910 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Can you advise of a macro to extract this? i have tried various formula combinations, arrays using a name range of the variables, but i cannot get it to consistently work.
Thank you in advance