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)