Or A1=account receivables B2=LEFT(PROPER(A1)) equals "A" (Notice the function proper capitalized the first letter on the text in A1)
Or if A1=[space]account receivables B2=LEFT(PROPER(TRIM(B1))) equals "T" (Notice it did not count the space at the begining of the text since the function Trim will remove all spaces from the text except for single spaces between words.
... hmmm, what about the possibility of an entery which starts witha number and space or a compination of both ex. " 9 account receivables"? ... is it possible that you will have such input?
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
function
example
input: Account receivables
answer: A
i need function(coding)