On Apr 6, 2:12*pm, "Rick Rothstein"
wrote:
I ran into a situation. In some cases, the 2nd set of bracketed
data could be 2 characters in length. Can you help me modify
your formula to cover this case ?

We will need a totally different formula in that case (this is why I asked
you do define the structure of your cell entries). Give this formula a
try...

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"[",REPT(" ",99)),99)),"]","")

Rick Rothstein (MVP - Excel)

Than you. Worked great !