Thread: Extract data from bracket
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kent Kent is offline
external usenet poster
  
Posts: 10
Default Extract data from bracket
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



Reply With QuoteReply With Quote