Special Character Meaning in MS Excel that You Must Know About

Maximum people are using ms excel in corporate and small business, but very few people know the meaning of special character, which is very different in excel. actually, we know these characters with a name but as per excel there names or meanings are totally different. so here in this post, we have explained to you that what is the name or meaning of these characters.

Meaning of Special Characters in Excel :

Character Name Meaning or Description of Character
{   } These are “Array Holders”
: This is for “Signals Multicell Ranges”
\    _ This is used for “Valid Name Characters” in excel
= It Denotes Beginning of Expression
!   # Both Signs are Denote “Errors”
”   ‘ It is “String Holders” as per excel rules
@ This Equivalent to “=”
% The symbol in excel – Divide by 100
& It is Called Concatenate in Excel
[   ] Both are the “Filename Holders”
;   , Called Separators
^ (   ) * –  +  / These are called “Arithmetic Operators”


So friends above are the meaning of special character’s meaning in excel. if we remember the name of these characters, it will be very easy to understand the formulas and errors. we have some more topics in excel which may be very useful for you, so check the links below:-


Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group
Nazim Khan - Author Image

Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]

Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.

Leave a Comment