please i need a function that will take this :

[mgm90210M]

please i need a function that will take this :
[dog muzzles]


and will write:
dog muzzles








and i need he same funcion that will take this :[leather dog collar]

and will write:
leather dog collar

 

[L. Howard]

From the macro recorder- find and replace.
Change range to suit.

Option Explicit
Sub Macro1()
'
' Macro1 Macro
'
'
    Range("C1:C10").Select
    Selection.Replace What:="[", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
    Selection.Replace What:="]", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub

Regards,
Howard

 

[Robert Mika]

Try:

Excel 2010
	A	B
1	[leather dog collar]	leather dog collar
2	[dog muzzles]	dog muzzles
3
Sheet1

Cell Formulas
Range	Formula
B1	=MID(A1,2,LEN(A1)-2)