Showing posts with label Excel Find all the data which start with XYZ. Show all posts
Showing posts with label Excel Find all the data which start with XYZ. Show all posts

Friday, 30 June 2017

Excel Find all the data which start with XYZ, till next number

Input: Column A-->
ABC-2123-XYZ-023111-Test-2-BOX-US-ZAW

Find all the data which start with XYZ, till next number
Formula:
=MID(A1,FIND("-XYZ",A1)+1,10)