Deleting backslashs and everything after
 

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

Deleting backslashs and everything after
 

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

Deleting backslashs and everything after
 

DataText to ColumnsDelimited 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
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

Deleting backslashs and everything after
 

On Sep 30, 3:14*pm, Claus Busch 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!