Can you provide more information Sam? Whilst the string length varies
do the numbers always come at the front or the end or do they appear
somwhere in the middle?

Is the format of the numbers always the same 123-456?

Do the numbers appear as a single substring or are they spread
throughout your text?

Sam wrote:
I need to remove text from cell and show only numbers
example number 510-889.

Each cell contains different amount of text.

Thanks!!