| 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
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! |
|
#4
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 |
| 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 | |||
Hybrid Mode
