Remove Text characters, leaving numerical characters

Try this one

Formula:

Please Login or Register  to view this content.

v	A	B
1	60.5 @ 5.25	60.5 @ 5.25
2	60.5 @ $5.25	60.5 @ $5.25
3	60 @ 5.25	60 @ 5.25
4	Santa Ana 60.5 @ 5.25	60.5 @ 5.25
5	Hillsboro 25 @ $4.89	25 @ $4.89
6	70.5 @ $5.95	70.5 @ $5.95

Hi neighbor to my south,

Try this formula for text in A1

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(A1," @ ","~")," ",REPT(" ",100)),100)),"~"," @ ")

PS - I like AlKey's answer better than mine!!

with your example and if lenght of formula does not matter:
B1:

Formula:

Please Login or Register  to view this content.

and CSE
C1:

Formula:

Please Login or Register  to view this content.

and CSE also.

result:

Please Login or Register  to view this content.

Edit Please ignore this formula / post. It doesn't work after all. Please see post below.

An afterthought.

You hadn't mentioned the possibility that text characters might be also at the end. I borrowed rather heavily from a method used by XOR LX for this. It will extract the numbers substring wherever they are in the string. It is also committed with Ctrl + Shift + Enter.

Formula:

Please Login or Register  to view this content.

No. Mine was only intended to take the #### @ ##### patterns out. It turns out my formula won't do that in too many cases. grrr.

If my formula did work it would return "25.5 @ Middle text 5.04" from your example. It is supposed to find the first and last number positions then extract everything between. My intent was to take care of strings like "Santa Ana 60.5 @ 5.25 on sale now" and return "60.5 @ 5.25". I goofed though. Should have done more than "borrow heavily" and tested more thoroughly.

This the actual formula from XOR LX I failed to adapt properly.

Formula:

Please Login or Register  to view this content.

Apologies for the oversight.