delete any word inside [ ] in excel with formula

[deeproject]

hi,

i have database with various word inside [ ] , i want to delete every last of them but keep the other word.
i been searching in web for hours but cant find it,

fot instance i have data like bellow

[TABLE="width: 657"]
<tbody>[TR]
[TD="width: 657"]Kayu Putih Rw 13 Kel Kayu Putih Kec Pulogadung [Permit Reject To Be Dismental Tiang Icon+][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 657"]
<tbody>[TR]
[TD="width: 657"]Pemukiman Rw 02 Kel Cilandak Barat Kec Cilandak [Area 70% Digusur Untuk Jalan Tol] [Permit By Inhouse : 26 09 2016][/TD]
[/TR]
</tbody>[/TABLE]
i want to clean up to

[TABLE="width: 657"]
<tbody>[TR]
[TD="width: 657"]Kayu Putih Rw 13 Kel Kayu Putih Kec Pulogadung
Pemukiman Rw 02 Kel Cilandak Barat Kec Cilandak

is there any formula to do it since the data about 1500

any help will be appreciated.

thankyou [/TD]
[/TR]
</tbody>[/TABLE]

 

[strooman]

Isn't this a simple Find and Replace?

Find what: [*]
Replace:

Replace with nothing

 

[JackDanIce]

It may be easier to use Text to Columns with delimiter option Other "[" to split the text out into columns to keep/delete

 

[Tim_Excel_]

On Error Resume Next
With Workbooks("NAME").Worksheets("NAME") 'change

For each Cell in .Range("A1:A1500") 'change
If err.number = 0 Then
charn = Instr(1, Cell.Value, "[")
Cell.Value = Left(Cell.Value, Len(Cell.Value)-(Len(Cell.Value)-charn))

End if
Next Cell

End With

This code does assume that there is no text that needs to be saved after the first "[", so take that in mind. If this is a wrong assumption, let me know

 

[steve the fish]

It seems the bracketed text is always at the end of the cell so you could use:

=TRIM(LEFT(A1,IFERROR(FIND("[",A1)-1,LEN(A1))))