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)