Dear Valko,

B1 works but C1 only returns an #VALUE!


Kent




"T. Valko" .gbl...
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