In my cell I wanted a formula to search another cell and to find and return the text which is between the characters "_" and "-".
For example, in Cell A1 i will have some text like "howiseveryone_p1929976-1460203" and in cell A2 i wasnt a formula to search cell A1 and take the text between the characters "_" and "-" and return the text in cell A2 which in the case is p1929976. Can someone please help.