Looking for excel regular expression.
After word CEO, pick next number group.
Possible number variations: "+358410 34123" or "045-231 442 111" or "+35850-312654" or "010 4444 222"...
Example: How to ReGex for CEO's number?
Sales Assistant
Pamela Jason, pamela@jason.doe
tel:010 2230 000
Ceo
<tbody>
</tbody>
Solution: 010 2810 920
After word CEO, pick next number group.
Possible number variations: "+358410 34123" or "045-231 442 111" or "+35850-312654" or "010 4444 222"...
Example: How to ReGex for CEO's number?
Sales Assistant
Pamela Jason, pamela@jason.doe
tel:010 2230 000
Ceo
John Doe tel: 010 2810 920 |
<tbody>
</tbody>
Solution: 010 2810 920