SUBSTITUTE function
now browsing by tag
AcroForms
add controls to form
Arbitration
Autoexpand
BookMarks
defined tables
Dynamic Hyperlinks
enable macros
Excel
Excel 1013
excel 2007
excel 2010
excel 2013
Excel Defined Names
Excel Linear Interpolation
Excel ScoreBoard
excel to pdf
excel userform
excel vba form
expand userform
Export XML Data From Excel
fill combo
Header Row
hide excel sheets
Mail Merge
Map Excel to Word
Mass Metters
PDF Form
pdf to excel
Ping Pong
protect sheet
range to array
Table Components
tables
Table Tennis
TextBox
TextBox Change Event
TextBox Exit Event
Totals Row
UDF
VBA Interpolate
vba user form
workbook protection
XFA Forms
XML Data
SUBSTITUTE function: Basic and Advanced Examples
SUBSTITUTE function type: Text
Description: Substitutes the old text with new text in a text string
Beyond its basic use, which is fairly simple, the SUBSTITUTE function can be very useful combined with other functions, to get your desired results.
Take a look at the advanced applications examples:
Applications:
- Substitute last occurrence only
- Extract partial string after last delimiter
- Extract item from delimited text, based on item position