Index
Avoid error displays such as #DIV/0 in formulas
| 20 | 10.00 | 0.00 | This is the result of the formula =IF(ISERROR(B20/C20),"",B20/C20) | |
|---|---|---|---|---|
| 21 | 10.00 | 0.00 | Oops! | This is the result of the formula =IF(ISERROR(B21/C21),"Oops!",B21/C21) |
Remove specific characters from text string
| 24 | Mr A N Other | MrANOther | This is the result of the formula =SUBSTITUTE(B24," ","") |
|---|---|---|---|
| 25 | ABC#Couriers | ABCCouriers | This is the result of the formula =SUBSTITUTE(B25,"#","") |
| 26 | My//Company/// | MyCompany | This is the result of the formula =SUBSTITUTE(B26,"/","") |
| 27 | My///Compa#ny#Ltd | MyCompanyLtd | This is the result of the formula =SUBSTITUTE(SUBSTITUTE(B27,"/",""),"#","") |
Useful Links
The following are the websites we believe to be the most useful for Excel & VBA information.
Pearson Consulting Software
Probably the best source on the internet for examples of Excel & VBA
The Spreadsheet Page
Excellent site with lots of information, examples and downloads.