#### saqibhanif37

##### New Member

I am confused with the array formulas and curly brackets used as functions but not array formulas. I do understand they look something like this

{=<formula line>}, I am wanting to learn, what does the curly bracket really do in excel if it is not an array formula? I mean there has been posts where people use functions, part of which is "...find({1,2,3,4,5,6,7,8,9,0},A2)..."

This function doesn't really appear to work if used like this:

Assuming Cell A2 is "Saqib6" and I use a function in B2 which is "find({1,2,3,4,5,6,7,8,9,0},A2), it wouldn't work. I'm only trying to understand the ligatures of the curly bracket.