Formula to add a dash it only if there’s no numbers
Enter the following formula in B1:
=IFERROR(IF(VALUE(LEFT(A1,3))>=0,""),IF(IFERROR(FIND("-",A1),0)>0,"", REPLACE(A1,4,0,"-")))
Drag it down to fill the other cells.
Enter the following formula in B1:
=IFERROR(IF(VALUE(LEFT(A1,3))>=0,""),IF(IFERROR(FIND("-",A1),0)>0,"", REPLACE(A1,4,0,"-")))
Drag it down to fill the other cells.