Extract numbers out of text cell entries

kno24ie

New Member
Joined
Nov 2, 2005
Messages
6
I have many text cell entries such as these samples:

AB1234C, D5678FC, EGH9012W, etc.

I just need to extract the numbers out of the middle of the entries. The numbers do not always start in the same position but are together.

Thank you in advance for the help!
Jerry
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
If there are always 4 digits:
=MID(A1,SEARCH({1,2,3,4,5,6,7,8,9,0},A1),4)
will work.
 
Upvote 0
If there are a variable number of digits you could use this array formula

=LOOKUP(9.99999999999999E+307,--MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"0123456789")),ROW($1:$255)))

confirmed with CTRL+SHIFT+ENTER

If there are always four digits

=MID(A1,MIN(FIND({1,2,3,4,5,6,7,8,9,0},A1&"0123456789")),4)+0
 
Upvote 0

Forum statistics

Threads
1,223,498
Messages
6,172,646
Members
452,467
Latest member
colelkay

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top