Add a Dash to a Number

I have cells with numbers such as 17889510482 and I need to add a dash so it reads 1788-9510482. Anyone have a formula to accomplish this, please? Thank you.

Based on the single sample that you shared, this will work:

=LEFT(A1,4)&"-"&RIGHT(A1,7)

BINGO! That worked. Thank you!!!

You're welcome. Happy to help.

Hi,

This would also work for your single sample:

Excel 2016 (Windows) 64 bit

	A	B
1	17889510482	1788-9510482

Sheet: Sheet96

Excel 2016 (Windows) 64 bit

	B
1	=REPLACE(A1,5,,"-")

Sheet: Sheet96