View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bayou Johnny Bayou Johnny is offline
external usenet poster
 
Posts: 1
Default How do I changet a text telephone number (xxx) xxx-xxxx to xxxxxx.

I have a data export that lists telephone number in a (xxx) xxx-xxxx format
that I need to change to a number format without spaces or commas. Anyone
know of a formula to apply to a column of text numbers to make such a
conversion within a spreadsheet?