substitute / trim

[gmazza76]

Good afternoon,

I am trying to align the formula below based on the length of the result if possible, but I am at a loss on how to do this.
Ideally the correct value I want is always more than 1 character in length, but I am unsure how to check this point instead of the "N" as there are more variable for the "N" than say being over 2 characters in length.

=if(TRIM(LEFT(SUBSTITUTE(MID(SUBSTITUTE('test'[column1],",","x",5),FIND("x",SUBSTITUTE('test'[column1],",","x",5))+1,99),",",REPT(" ",99)),99))="N",
TRIM(LEFT(SUBSTITUTE(MID(SUBSTITUTE('test'[column1],",","x",7),FIND("x",SUBSTITUTE('test'[column1],",","x",7))+1,99),",",REPT(" ",99)),99))

Thanks in advance
Gavin

 

[Sufiyan97]

Provide some sample text and expected result to show what you want to get as result