Thread: Revision
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Revision
If all you are concerned with is to extract the phone number in D2,
then in D2:

=RIGHT(C2,8)

HTH
Kostis Vezerides

Reply With QuoteReply With Quote