Conditional Substring

[Alisea_MI]

Hi,

I need to set up a conditional column, which looks at the first three characters in a text column and if the third character is " ", it should return the first two characters, else "null".

Example: ZW BY 34 should return ZW.  SSRS 43 YT should return "null". 

Would be grateful for any input on this!

[Alisea_MI]

Thank you so much, @DataZoe ! Works perfect!

[DataZoe · Accepted solution]

@Alisea_MI You could try a calculated column such as 

Substring = 
IF (
MID ( Customer[Name] , 3, 1 ) = " ",
LEFT ( Customer[Name] , 2 ),
BLANK ()
)