extract numbers from cell containing text & numbers

[transferxxx]

Any formula I can use to extract the phone extension from this cell
which contains both Department & extension in a cell
e.g Gift Collection 7709

Thxs

 

[Biff]

Hi!

Based on that single example:

=RIGHT(A1,4)

Are all the extensions 4 digits? Are the extensions always at the end? If
not, post more representative samples.

Biff