How can I bypass "formula errors"?

%3CLINGO-SUB%20id%3D%22lingo-sub-3327439%22%20slang%3D%22en-US%22%3EHow%20can%20I%20bypass%20%22formula%20errors%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3327439%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20make%20a%20grammar%20chart%20for%20word%20endings%2C%20which%20would%20basically%20consist%20entirely%20of%20%22formula%20errors%22%20-%20that%20is%2C%20for%20example%2C%20entries%20such%20as%20%22-us%2C%22%20%22-%C4%AB%2C%22%20and%20%22-%C5%8D%22%20in%20each%20cell%3B%20however%2C%20as%20you%20can%20clearly%20see%2C%20these%20aren't%20intended%20formulae.%20When%20I%20move%20on%20to%20the%20next%20cell%2C%20whatever%20I%20just%20typed%20immediately%20turns%20into%20%22%23NAME%3F%22%20How%20can%20I%20bypass%20this%20error%20so%20it%20doesn't%20think%20they're%20supposed%20to%20be%20formulae%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3327439%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3327479%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20bypass%20%22formula%20errors%22%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3327479%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382279%22%20target%3D%22_blank%22%3E%40Hunter_D%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOption%201%3A%20format%20the%20cells%20you're%20going%20to%20enter%20these%20endings%20in%20(for%20example%20a%20column)%20as%20Text%20%3CEM%3Ebefore%3C%2FEM%3E%20you%20start%20entering%20values.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOption%202%3A%20prefix%20each%20such%20value%20with%20a%20single%20straight%20quote%20'.%20This%20instructs%20Excel%20to%20treat%20the%20value%20as%20text.%20For%20example%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E'-us%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20single%20quote%20will%20be%20displayed%20in%20the%20formula%20bar%2C%20but%20not%20in%20the%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I'm trying to make a grammar chart for word endings, which would basically consist entirely of "formula errors" - that is, for example, entries such as "-us," "-ī," and "-ō" in each cell; however, as you can clearly see, these aren't intended formulae. When I move on to the next cell, whatever I just typed immediately turns into "#NAME?" How can I bypass this error so it doesn't think they're supposed to be formulae?

 

Thanks.

1 Reply

@Hunter_D 

Option 1: format the cells you're going to enter these endings in (for example a column) as Text before you start entering values.

 

Option 2: prefix each such value with a single straight quote '. This instructs Excel to treat the value as text. For example:

 

'-us

 

The single quote will be displayed in the formula bar, but not in the cell.