This was from an old thread about extracting domains from a URL, but this is a question about *HOW* you (any expert) visualise this formula before writing it? Do you write the core and then add refinements?
What is a good method of learning to write such formulas?
What is a good method of learning to write such formulas?
I didn't even notice the "dots" were gone. Okay, let's just SUBSTITUTE the spaces away...
=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(TRIM(TRIM(LEFT(SUBSTITUTE(TRIM(IFERROR(MID(A1,FIND("://",A1)+3,99),A1))&"/","/",REPT(" ",99)),99))),".",REPT(" ",99)),99*(2+(LEN(TRIM(RIGHT(SUBSTITUTE(TRIM(TRIM(LEFT(SUBSTITUTE(TRIM(IFERROR(MID(A1,FIND("://",A1)+3,99),A1))&"/","/",REPT(" ",99)),99)))&".",".",REPT(" ",99)),198)))=2))))," ",".")