Deleting backslashs and everything after

[wesley holtman]

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

 

[Claus Busch]

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

 

[Gord]

Data>Text to Columns>Delimited by backslash.

Select second column to "skip" and Finish.


Gord Dibben Microsoft Excel MVP

 

[wesley holtman]

Hi Wesley,

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


Edit => replace
what: /*
with: nothing

Regards
Claus Busch

Thanks Claus, worked perfectly!