Tuesday, 28 July 2009

Choosing the existing text in brackets

Maybe there are friends who sometimes find the excel data format such as the table below

look at column A, contain data a name and email,
in the following cases we can choose an email-only (character / text in bracket)




To select an existing text in brackets, on the cell B5 type the formula:

= MID (A5, FIND ("(", A5) +1, FIND (")", A5)-FIND ("(", A5) -1)




No comments:

Post a Comment