insert a "-"

[tpkelley_no]

I have a excel work sheet that I exported. in column "D" i have cost codes. for example 00-105, 00-600. some of them do not have a dash. for example 01600, 05300. What would be the fasted was in adding a "-" when missing?

 

[Ingolf]

Re: incet a "-"

Or

=REPLACE(A2,3,0,"-")

 

[Peter_SSs]

Re: incet a "-"

try:

=REPLACE(A2,3,1,"-"&MID(A2,3,1)) assuming that string is in A2

Or

=REPLACE(A2,3,0,"-")

Neither work very well for those cells that already have a "-" in them.

 

[tpkelley_no]

Re: incet a "-"

the formula did not work here is a sample of the cell

<colgroup><col width="81"></colgroup><tbody>
[TD="class: xl63, width: 81"]04830-Total
[/TD]

</tbody>

is need to be 04-430. only the "04-430"
TY

 

[tpkelley_no]

Re: incet a "-"

it worked TY!!!