nevermind, got it
Where 1 is the number of characters you want to extract.Code:newString = left(originalString, 1)
there is also a worksheet function that does the same:
where A1 is a cell containing the string to evaluate (you can also input the string directlly into this formula instead of the cell reference if you want to.)
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)