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”

Download Free Excel Files

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

Join the TechGuruPlus Telegram group

Join Our WhatsApp Group

Join the TechGuruPlus WhatsApp group
Nazim Khan, founder of TechGuruPlus.com

Founder & Editor, TechGuruPlus.com
[MBA in Finance]

Nazim Khan has spent over ten years working with Excel, Tally and office documentation in accounts, finance and MIS roles. He has been running TechGuruPlus.com since 2016, where he publishes free editable templates for office work, and the YouTube channel Business Excel. He has trained more than 50,000 people online. Every template on this site is built and checked by him before it is published.

Contact  ·  Excel Course

Leave a Comment