Moving ‘find’ results to new cell (Excel 2003)

Topic

New Reply

I need a formula that will allow me to extract the number from parentheses in a cell, move the number to an adjacent cell, and delete it and the parentheses from the original cell, leaving just the numbers in the adjacent cells (see attachment). I want to covert column A into columns B and C. Can anyone help me out?

Thanks,

Reply | Quote

Replies

In B2:

=VALUE(LEFT(A2,FIND("(",A2)-1))

In C2:

=VALUE(MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1))

Copy (autofill) B2:C2 to B3:C21

Steve

Reply | Quote

Thank you. Worked perfectly.

Reply | Quote