Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL

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)