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)

Related Posts by Categories

No comments:

Post a Comment

Random Posts