• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract only text

H

Hans Knudsen

Member
Will someone help me understand the format codes in bosco_yip's formulas in this thread

Extract only text

I have a text in a1 = "ab50,bc60", i want result in b2 as "abbc"
chandoo.org

(The format codes are "0;;0;" respectively ";;")
 

Hans Knudsen​

To create a custom number format, you start by selecting one of the built-in number formats as a starting point. You can then change any one of the code sections of that format to create your own custom number format.

A number format can have up to four sections of code, separated by semicolons. These code sections define the format for positive numbers, negative numbers, zero values, and text, in that order.

<POSITIVE>;<NEGATIVE>;<ZERO>;<TEXT>
with text-function
for numbers "0;;0;"
for texts ";;"
 
Thank you.
I know about the four sections of code and I know the TEXT function. Still it is not obvious to me why the code for numbers is "0;;0;" and for texts ";;". Is this explained anywhere?
 
0;;0;
will only display positive numbers and 0 values (the negative and text sections being blank).
";;"
has all the number sections blank, so would only return text.
 
You must log in or register to reply here.
Back
Top