Hi Basically there is no specific formula for a substring in excel, but u can use different functions like MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM, and MAX in Excel to extract substrings.
To extract a substring, starting in the middle of a string, use the MID function in Excel.
This basically takes the mid operation that is from the center of the string operation
To extract the leftmost characters from a string, use the LEFT function in Excel.
This basically takes the left most part of the string
Ex: ABC_103 and u use left operation in the excel the output will be ABC
To extract the rightmost characters from a string, use the RIGHT function in Excel.
This basically takes the right most part of the string .