Share this Page URL
Help

Chapter 15. Text Functions > SUBSTITUTE - Pg. 309

Text Functions 309 Figure 15.10. You can add ordinals to the end of numbers automatically. SUBSTITUTE The SUBSTITUTE function replaces old text within a text string with new text. =SUBSTITUTE(text,old_text,new_text,instance_num)