Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Please I've been trying to discover a way to insert a dash automatically in
many phone numbers without dashes already input in a single column in Excel. The phone numbers are all unique so I can not use Find and Replace method with the asterisk wildcard. The only consistent factor is the dash would be inserted after the first 3 digits of each phone number in the column. Thanks for any help or tips! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
Challenging Charting | Charts and Charting in Excel | |||
Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
Phone Numbers | Excel Worksheet Functions |