FIND returns 1 when find_text is empty. The first two methods are all complex for most of our Excel users here I can create a VBA code to solve this job quickly and easily. It can be used as a worksheet function WS in Excel.
Ok lets look at the FIND syntax then.
You need to be able to select all the data without selecting any other values. To get the correct result you must sort the number list in descending order first. Lets now review the steps to get all the digits after the symbol of - for varying-length strings. The Excel launch page will open.