What is open square bracket in excel?
Shiv Mahima OjhaAsked:
Who is Participating?
Bill PrewCommented:
Another use of square brackets in formulas is when referencing a cell in another workbook, so if Book1 wants to reference a cell in Book2 it would use:


Justin EvansCommented:
The open square bracket is used for column references.

please see this website below for an example


kind Regards

Bill PrewCommented:
Do you mean in Excel formulas?  If so, please provide a sample of a formula you are seeing this, it can indicate several things, so hard to be sure without seeing your formula.

Another purpose for them in a formula is if you use "R1C1" cell addressing, rather than "A1".  For example this formula in cell A1:


Would refer to the contents of cell B2.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.