You can use formatting to display dashes in phone numbers. If these have
been entered as numbers (no hyphens, no brackets):

Select the cells with phone numbers
Choose FormatCells
On the Number tab, select the Special category
Choose Phone Number, click OK

LemonLiptonTea wrote:
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!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html