(###) ###-####
RusselB wrote:Highlight the cell(s)/row(s)/column(s) that you want formatted in that manner.
Right click and select Format Cells
Under the Numbers tab, select User-Defined and enter
- Code: Select all Expand viewCollapse view
(###) ###-####
acknak wrote:Select the cells (or column) you want to change
Edit > Find & Replace
Search for: ^\D*(\d{3})\D+(\d{3})\D+(\d{4})\D*$
Replace with: ($1) $2-$3
Match case: YES
Options/Regular expressions: ON
Options/Current selection only: ON
Click "Replace All"
This works with all your examples; it should cover most other cases as well.
Users browsing this forum: Google [Bot] and 12 guests