Link to home
Start Free TrialLog in
Avatar of Brent
BrentFlag for United States of America

asked on

Breakdown Formula - { } - What do brackets mean?

Hi,

I am using a piece of code I found earlier from on old thread from Google.

=LEFT(C2,MIN(FIND(0,SUBSTITUTE(C2,{1,2,3,4,5,6,7,8,9},0)&0))-1)

Open in new window


It works perfect to separate text from numbers, but I am not sure how the { } play into the formula. The rest I can understand, but it is killing me not to get that part of the formula.

I usually mark where I found the formula, but I did not think I would use it, so sorry for not referencing the OP.

thanks,
Brent
ASKER CERTIFIED SOLUTION
Avatar of LCCSAM
LCCSAM
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Brent
Brent
Flag of United States of America image

ASKER

I thought it was an array, but I also thought I needed to press CTRL+Shift+Enter to make it an array. But, from reading I guess if you place them inside a formula, then you don't need to do the CTRL+Shift+Enter

Thanks!
Avatar of Brent
Brent
Flag of United States of America image

ASKER

Thank you.
Avatar of LCCSAM
LCCSAM
Flag of United States of America image
No problem at all!

What the formula you have is doing (The array portion) is giving a set of possible values of  "Old Text" to replace.

Let me know if you have any further questions!
Avatar of Brent
Brent
Flag of United States of America image

ASKER

Thanks. I am good on this one for now. It was driving me crazy not figuring it out. I don't mind borrowing formulas, but I really do want to understand what they are doing!