Inserting Dashes in a Column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

12356789 in column a1

I want to put in column a2 123-567-89

Whats the formula to put dashed in between the numbers without havin to
retype 20000 numbers.

Thanks
 
Try changing the format for your cells. Select your cells. Right-click on
them and select Format Cells. Under Category, select Custom. Type the
following:

###-###-##

Hope this helps,
Paul
 
If you actually want the dashes stored in a cell, the formula would look like:

=left(a1,3)&"-"&mid(a1,4,3)&"-"&right(a1,2)
 
You need to format the cell. Click Format>Cell>Number>Custom then under Type
create your format thus:- 000-000-00
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing Dashes 2
Number formating 4
Unformating social security numbers 4
Text to column where to put result 5
Countif(len(Range)>4) 2
Eliminating the dashes 3
Forumla rows and columns 3
If then Formula 3

Back
Top