[Solved] Text find the result nos

[parveengarh]

Text	Result
65GRFLOORSHOPNO978SHREEKRISHNAPARADISENAVIMUMBAI410210TOLLFREENUMBER56789	410210

 

[MD Tanvir Rahman]

Text	Result
65GRFLOORSHOPNO978SHREEKRISHNAPARADISENAVIMUMBAI410210TOLLFREENUMBER56789	410210

Dear @parveengarh, welcome to ExcelDemy Forum and thank you so much for your unique query.

Yes, you can extract "410210" from "65GRFLOORSHOPNO-978SHREEKRISHNAPARADISENAVIMUMBAI410210TOLLFREENUMBER56789" by applying the following formula containing Excel TRIM, FIND, MID, LEN functions.

=TRIM(MID(A3, FIND("MUMBAI", A3) + LEN("MUMBAI"), FIND("TOLLFREENUMBER", A3) - FIND("MUMBAI", A3) - LEN("MUMBAI")))



I have attached the Excel file as well. Please let me know if you face any further shortcomings. Furthermore, there are some similar readings that may help you for better understanding.

• Extract Only Numbers from Excel Cell
• Extract Specific Numbers from a Cell in Excel
• Find Multiple Numbers from String in Excel

Thank you and have a good day. Please hit (Thumbs up) if the solution helps you. Also, don't forget to remember us for any further shortcomings. We, team ExcelDemy are ready to serve you with our knowledge, skills, expertise, and resources.

Regards,
MD Tanvir Rahman
Excel and VBA Content Developer
ExcelDemy