View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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