ExcelBanter - insert a dash

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - insert a dash (https://www.excelbanter.com/excel-programming/347513-insert-dash.html)

acp20770

insert a dash

I have a column of 5-digit numbers. How do i insert a dash into each number
after the 3rd digit?

Bob Phillips[_6_]

insert a dash

Use a custom format of 000-00

--

HTH

RP
(remove nothere from the email address if mailing direct)

"acp20770" wrote in message
...
I have a column of 5-digit numbers. How do i insert a dash into each
number
after the 3rd digit?

galimi[_2_]

insert a dash

Enter the following formula in an adjacent column

=left(a1,3) & "-" & right(a1,2)
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758

"acp20770" wrote:

I have a column of 5-digit numbers. How do i insert a dash into each number
after the 3rd digit?

All times are GMT +1. The time now is 02:58 AM.