As per attachment i have column A having name with underscore "_' and bracket " [ " . I need a formula to get answer of column B means I need formula to get id before underscore and inside bracket .
now am doing by Data--> Text to Column , feel its not a good way because A column is splitting into 2 . enter image description here Hoping anyone can help me