Using IF statement to Pull Any Value That Starts with a Letter

Hello!

I am wanting to know if there is a way to use IF statements (or some other formula) to pull if values in a certain column start with any letter vs a number. In my scenario, Column A has a list of reference numbers that can start with any combination of letters OR numbers, and I want to know if there is a formula I can use to pull back a result that will tell me if that value starts with a letter, specifically.

Thank you ahead of time!

You could try something like this in B2:

=IF(AND(CODE(UPPER(LEFT(A2)))>64,CODE(UPPER(LEFT(A2)))<91),"Letter","Other")

Hope this helps.

Pete

Hello,

I ran this function exactly as laid out above, and all values returned as "TRUE" whether the value started with a number or letter, so this did not work.

It shouldn't produce TRUE, so you must have changed the formula. It worked for me on some sample data that I put together.

Pete

Thank you Pete! That worked! And my apologies, I did not see your response at the time that I had replied!

Thank you all again!

Glad to hear that it worked for you.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete