Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Extract words

0

Hi,

I need to extract middle text in a single word.

e.g. AB00123456@abcd.com

answer will be 123456.

Any help?

Answer
Discuss

Answers

1
Selected Answer

This should be shorter....But for now.

=MID(REPLACE(A1,FIND("@",A1),LEN(A1),""),MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),99)/1                   

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login