Showing posts with label Choosing the existing text in brackets. Show all posts
Showing posts with label Choosing the existing text in brackets. Show all posts

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)




Random Posts