### Excel Magic Trick # 277: Add 01-12-13-14-15 Text String From

See how to use the SUBSTITUTE and Morefunc EVAL functions to take a text string series of numbers and add them. Also see how to create a global relative cell reference named formula that you can use anywhere in a workbook.

Length:
04:31