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

wrote in message
oups.com...
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