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