Using LEFT RIGHT LEN TO reverse and trim first name and last name

[alphabex18]

I have a cell (A1) that looks like this:

Last Name, First Name [000100833-RWURL] I need a formula to trim the [000100833-RWURL] , which is always 17 characters with the brackets, and then put the first name first and the last name last with no comma

<colgroup><col width="321" style="width: 241pt; mso-width-source: userset; mso-width-alt: 11739;"> <tbody> </tbody>

this is where I am at so far, but I cant seem to rid the additional items within the brackets
=RIGHT(A1,LEN(A1)-(SEARCH(",",A1,1)+1))
&" "
&LEFT(A1,SEARCH(",",A1,1)-1)

Thanks for any help

 

[AlKey]

Try this

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

Excel 2016 (Windows) 32 bit
	A	B
1	Clooney, George [000100833-RWURL]	George Clooney
Sheet2

 

[AhoyNC]

Another option

Excel Workbook
	A	B
1	Smith, John [000100833-RWURL]	John Smith
2	Johnson, Mary Ann [000200865-RWURL]	Mary Ann Johnson
Sheet