Hi,
I am using power query and want to perform a simple algorithm.
In column A I have three characters. If the second character is a number I want to extract the first character. If the second character is a letter, want to extract the first two characters.
Not able to do this with “Add Column” => “Conditional Column” so some help would be appreciated.