• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Text Functions > Troubleshooting

Troubleshooting

Text in Formulas

When using functions such as LEFT and RIGHT, I get the #NAME? error.

If you're placing text in formulas, enclose the text in quotation marks, such as =RIGHT("Bill",2). An easier way would be to place Bill in a cell such as A1, and then the formula could be used with cell referencing such as =RIGHT(A1,2).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint