Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need a macro to do the following in B3:B500
If(right(......,5)="Total" Delete Right(........,6) Hope this is clear |
#2
![]() |
|||
|
|||
![]()
something like
for each c in selection if right(c,5)="Total" then c.value=left(c,len(c)-5) next -- Don Guillett SalesAid Software "Esrei" wrote in message ... I need a macro to do the following in B3:B500 If(right(......,5)="Total" Delete Right(........,6) Hope this is clear |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
how do I delete a worksheet from my workbook | New Users to Excel | |||
Delete row depending on criteria | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
How to delete blank rows | Excel Discussion (Misc queries) |