Help Creating Two Columns from One

I'm not sure that this is the best place to post this quesiton but I'll ask it here anyway hoping that it can be placed in the best place.

I need to extract text from cells that lie between left and right brackets.

Here's a sample of my data. There are four scenarios that show up in the column of data.

Column 1
D32B02 [8079ZC]
B09A01 []
[8019C/A]
[]

What I need to see after all is said and done is two columns. One with anything that is before the left bracket and one with everything between the two brackets.

Example:

Column 1 ................. Column 2
Bin Location ............. Old Part Number
D32B02 .................... 8079ZC
B09A01 .................... empty
empty ...................... 8019C/A
empty ...................... empty

Anybody have any ideas on how to accomplish this? I can't for the life of me figure out how to make this happen. I've got ASAP Utilities which is incredible but I don't see anything in it that would do this.

Help would be greatly appreciated.

Thanks,

Jeremy

Try:

=LEFT(A1,FIND("[",A1)-1)

and

=MID(A1,FIND("[",A1)+1,LEN(A1)-FIND("[",A1)-1)

where A1 contains original... and copy down.