Hello,

I have 1800 rows of muni bond ratings that were saved in the wrong
format. Does anyone know how to loop threw a range and finding all
cells that contain a backslash and deleting it and everything after
it?

Thanks

Hi Wesley,

Am Fri, 30 Sep 2011 12:01:13 -0700 (PDT) schrieb wesley holtman:

> I have 1800 rows of muni bond ratings that were saved in the wrong
> format. Does anyone know how to loop threw a range and finding all
> cells that contain a backslash and deleting it and everything after
> it?

Edit => replace
what: /*
with: nothing


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Data>Text to Columns>Delimited by backslash.

Select second column to "skip" and Finish.


Gord Dibben Microsoft Excel MVP

On Fri, 30 Sep 2011 12:01:13 -0700 (PDT), wesley holtman
<(E-Mail Removed)> wrote:

>Hello,
>
>I have 1800 rows of muni bond ratings that were saved in the wrong
>format. Does anyone know how to loop threw a range and finding all
>cells that contain a backslash and deleting it and everything after
>it?
>
>Thanks

On Sep 30, 3:14*pm, Claus Busch <claus_bu...@t-online.de> wrote:
> Hi Wesley,
>
> Am Fri, 30 Sep 2011 12:01:13 -0700 (PDT) schrieb wesley holtman:
>
> > I have 1800 rows of muni bond ratings that were saved in the wrong
> > format. Does anyone know how to loop threw a range and finding all
> > cells that contain a backslash and deleting it and everything after
> > it?
>
> Edit => replace
> what: /*
> with: nothing
>
> Regards
> Claus Busch
> --
> Win XP PRof SP2 / Vista Ultimate SP2
> Office 2003 SP2 /2007 Ultimate SP2

Thanks Claus, worked perfectly!