How to split and read first character of string

@Rhys18 ,

Considering the conditions mentioned, from the String data provided, How would you Output it to excel and which would be the 3 values that you would choose if done manually ?