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 The-PC-Guy Your Own Question
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 1997
Experience:  20 years experience providing remote computer support
62934938
Type Your Microsoft Office Question Here...
The-PC-Guy is online now
A new question is answered every 9 seconds

extract numbers from a cell

This answer was rated:

I am trying to extract numbers from a cell containing numbers and alpha letters. Would you please write a formula to perform this task. For example the cell contains the following.

L753A or L791AE or R531BDF

I want to copy only the numbers to another cell. 753 etc.

Thanks, John
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question

is it always going to follow this format

a letter
then 3 numbers
then a bunch of letters?
Customer: replied 4 years ago.

Yes, it is a letter, then 3 numbers, then no letter or 1 to 4 or 5 letters

ok then that formula is easy. as long as there are always 3 numbers and they always start in the same place.

lets say your letter/number sequence are in column A and begin on row 2.

This formula would refer to Cell A2, and you would enter it in B2. If you need to refer to a different cell you would just simply change all occurrences of A2 in the formula to whatever cell you want to refer to.

=CONCATENATE(MID(A2,2,1),MID(A2,3,1),MID(A2,4,1))

once you get the correct cell reference in the formula you can just copy and paste the formula down your entire column and it will extract the 3 numbers from each occurrence in the referred to column. In this example thats column A.

Let me know if you get stuck or have any questions. Should be pretty straight forward, but I am here if you need me.


PLEASE DON'T FORGET TO RATE SO I AM PAID FOR MY TIME

IT WILL NOT COST ANYTHING ADDITIONAL BEYOND THE VALUE OF YOUR QUESTION

TO RATE, CLICK THE LaughingHAPPY FACELaughing or "GOOD" or "EXCELENT" service
The-PC-Guy and other Microsoft Office Specialists are ready to help you