Extract number from email adress via function

[dobracik]

Hi all,

I was wondering whether here is somebody who could help me to solve I believe simple issue.
I have an email together with number which I need to extract to other cell.

[email protected]

Is it possible to help me with function, which will extract number 1 to next cell? I have a long list of this kind of emails and need to take the numbers out to be able to use them for analysis.

Thanks :-)

[Richard Buttrey]

Hi

If the numbers are always preceded with a - then

Please Login or Register  to view this content.

[dobracik]

H iRIchard,

wau, super thanks a lot.
While checking I see that I have a email addresses where "-" is prior @, so function is not able to take the ended number :-(
Each email ended as ".com-" if this help :-)

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	[email protected]	123
2	[email protected]	1

[Richard Buttrey]

Would you show specific examples of all arrangements of text strings.

[dobracik]

thanks to both, working now :-)