extract numbers from cell containing text & numbers

  • Thread starter Thread starter transferxxx
  • Start date Start date
T

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
 
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
 
Back
Top