Try SUBSTITUTE() with the text in cell A1

=SUBSTITUTE(A1,"-",,1)

--
Jacob (MVP - Excel)


"Randy" wrote:

I have numbers in column A that don't belong such as;
74-350-77-50
18-350-077-51
36-100-001-03

the 3rd digit should not be a "-"
the rest of them would read
74350-77-50
18350-077-51
36100-001-03

What I need to do is find them and delete that row

Any ideas?
--
Randy