Extract data from bracket
Try these...
B1:
=LEFT(A1,FIND(" ",A1)-1)
C1:
=--SUBSTITUTE(MID(A1,FIND("(",A1)+1,10),")","")
--
Biff
Microsoft Excel MVP
"Kent" wrote in message
...
Dear all,
I have 3 coulumns of data
A B C
May (17) May 17
Peter (25) Peter 25
Jason (5) Jason 5
By formula, how to extract column B and C from column A?
Thank you
Kent
|