Extract Data From Column Using Mid & Search Function (1)

This is a Microsoft Excel Combination Formula Question: In this an excel column has data strings in which some of the string are bracketed in square and curly brackets like {*} and [*]. We have to extract the data from these brackets and put them in different columns. To achieve this we are using combination of Mid and Search function. Search function find the position of string in the cell string and Mid function extracts the specific data from the cell string. For any doubt or clarification , please comment or connect me at any of the following : Gmail : [email protected] Whatsapp : 917020540295 LinkedIn : https://www.linkedin.com/in/amitamu Facebook : https://www.facebook.com/amitforamit Instagram : https://www.instagram.com/curquest Twitter : https://twitter.com/curquest