How to delete Certain Characters in a excel 2010 cell

Asked 2013-07-15T10:43:29.190

In column A I have a load of name that look like this

[John Smith]

I still want them in A but the [] removed...

excel character excel-2010 cell

Edit Report

1 Answer

Another option: =MID(A1,2,LEN(A1)-2)

Or this (for fun): =RIGHT(LEFT(A1,LEN(A1)-1),LEN(LEFT(A1,LEN(A1)-1))-1)

answered 2013-07-15T13:28:55.113