Re: Extract The First Letter Of A String
LEFT(TRIM(B1),1)
By using the TRIM function, you will remove all leading spaces at the beginning of the string.
By using the LEFT function on the previously trimmed string, the returned character will be the first non-blank character from the string, be it a letter or number.