How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 38528
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I need help with an Excel 2010 problem. I am trying to use

This answer was rated:

I need help with an Excel 2010 problem. I am trying to use a function to simplify a process. I have a list with thousands of values that need to be separated. Right now I have to do it manually but I'm sure that there has to be an easy function that will save hours of time. My spreadsheet looks like this
Is there any formula that I can use that will eliminate the letter at the end of the number, or something that I can use that will give me an "N/A" or blank space for all values that have a "b" or "c" at the end?
Thank you very much!
Thank you for your question, my name is Richard.

Yes you can, you use this formula in the cell next to it

I assume the first cell that has the value is A1


Then copy that formula all the way down and it will display the value without the last character.

If you have any difficulties at all, please do not hesitate to let me know so I can assist you further

Thank you
Richard and other Microsoft Office Specialists are ready to help you