My Computer Dummies
Articles and tutorials about blog, internet and computer
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
‹
›
Home
View web version
No comments:
Post a Comment