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, 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

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.

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 HAPPY FACE or "GOOD" or "EXCELENT" service

The-PC-Guy and other Microsoft Office Specialists are ready to help you