Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Custom Views when Deleting Sheets | Excel Programming | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Deleting Hyphens or Dashes from multiple cells without deleting the remaining content | Excel Programming |