Substitute Replace
Excel » Substitute Replace »
Substitute multiple text strings [UDF]
The SUBSTITUTE and REPLACE functions can only handle one string, the following User-Defined Function (UDF) allows you to substitute multiple […]
VB for Applications
Functions
Methods
Properties
Statements
VBA
Multiply numbers in each row with remaining rows in cell range (UDF)
How to save specific multiple worksheets to a pdf file programmatically
Find literal values in formulas
How to create a list of comments from a worksheet programmatically
How to highlight row of the selected cell programmatically
Count text string in all formulas in a worksheet [VBA]
Copy worksheets in active workbook to new workbooks
Create comment if cell value is larger than column
Excel » Substitute Replace »
Formula categories
Count Dates Extract Index and Match Logic Lookups String manipulation Sum Time Vlookup