extract numbers from cell containing text & numbers

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

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

<[email protected]> wrote in message
news:[email protected]...
> 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
>