get char excel code example

Example 1: excel get some char from string

LEFT(text, [num_chars])

Example 2: extract letters from a string

Extract  numbers from a string

Character.isDigit(str.charAt(i))
Character.isLetter(str.charAt(i))
Character.isAlphabetic(str.charAt(i))

String password = "cnE4g1Z5y9A";	
String[] letters= password.split("[0-9]");    ==> cnEgZyA
String[] letters= password.split("[A-Za-z]");    ==> 4159