Prev: Date Ranges
Next: Need help for multiple entries
From: Randy on 27 May 2010 16:12
Thanks for getting back so soon, however I don't want to replace the dash, I
want to delete any rows where the 3rd character = "-"
--
Randy


"Jacob Skaria" wrote:

> 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
 | 
Pages: 1
Prev: Date Ranges
Next: Need help for multiple entries