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
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 31236
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
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
HME-101a
HME-101b
HME-102a
HME-102b
HME-103a
HME-103b
HME-104a
HME-104b
HME-104c
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

=left(A1,7)

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 5 other Microsoft Office Specialists are ready to help you