Remove alphabets from number string in a cell

Hey guys,

I am trying to remove alphabets that are mostly attached at the end of sets of numbers in my workbook. I've attached a sample file that shows what I currently have and what I am trying to achieve. Some numbers can be 10 digits long and some can be less than 10 digits long, both will have a letter attached to them at the end. I tried just removing the last value but there are cells with just numbers and that logic did not quite work for me.

Any help is appreciated

thanks in advance

VJ

Thanks for your response Alan.

I tried downloading the file that you've attached to see what you have done, but I am not able to. It redirects me to a page where it wants me to login but when I try, it says I may not have privilege to the link. Do you know why?

VJ

Hi John

Thanks for the formula. It worked for the most part. I also have some cell values that are like "101-21" and the formula removes the numbers after the "-" giving an output "101". Is there a way to fix this?

VJ

Originally Posted by JohnTopley

Try

=IF(CODE(RIGHT(A2))>=65,LEFT(A2,LEN(A2)-1),A2)

If this does not provide solution then please provide a better sample of your data.

I've attached the updated sample file with data similar to the actual data. Column A is the actual data and Column D is the result I want to achieve.

I hope this sample data is clear as each cell represents the actual length of my original data.

VJ

Alan,

It worked this time. I wasn't sure why I had that issue earlier downloading the file. Never had it before, but, I downloaded the file this time.

Thanks for you help

VJ

it worked. Thanks again John

VJ