I macro which gets me the numbers

[nico_neoz]

Hi there,

I have attached an excel sheet which describes my requirement.
I have a range of cells in which each cell contains a text followed by a '@' symbol and then number. I need just the numeric part.
I need ideas as to how to get the desired resut.

abc@123	[email protected]	[email protected]
123	98.00	54848.645

[nilem]

maybe this

Please Login or Register  to view this content.

[nico_neoz]

It worked Nilem!

Can you explain the formula you have used. Also help me as to how to set this formula as a function so that I can use it on a range of cells.