[excel] How to delete Certain Characters in a excel 2010 cell

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

[John Smith]

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

This question is related to excel character excel-2010 cell

The answer is

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)

If [John Smith] is in cell A1, then use this formula to do what you want:

=SUBSTITUTE(SUBSTITUTE(A1, "[", ""), "]", "")

The inner SUBSTITUTE replaces all instances of "[" with "" and returns a new string, then the other SUBSTITUTE replaces all instances of "]" with "" and returns the final result.

Replace [ with nothing, then ] with nothing.

Source: Stackoverflow.com

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to character

• Set the maximum character length of a UITextField in Swift • Max length UITextField • Remove last character from string. Swift language • Get nth character of a string in Swift programming language • How many characters can you store with 1 byte? • How to convert integers to characters in C? • Converting characters to integers in Java • How to check the first character in a string in Bash or UNIX shell? • Invisible characters - ASCII • How to delete Certain Characters in a excel 2010 cell

Examples related to excel-2010

• Get list of Excel files in a folder using VBA • filter out multiple criteria using excel vba • Swap x and y axis without manually swapping values • Excel 2010 VBA - Close file No Save without prompt • Removing special characters VBA Excel • Creating a list/array in excel using VBA to get a list of unique names in a column • Excel formula to get week number in month (having Monday) • Excel VBA Run-time Error '32809' - Trying to Understand it • IF statement: how to leave cell blank if condition is false ("" does not work) • Excel how to find values in 1 column exist in the range of values in another

Examples related to cell

• Excel doesn't update value unless I hit Enter • Excel Define a range based on a cell value • Link a photo with the cell in excel • VBA setting the formula for a cell • Changing datagridview cell color dynamically • How to delete Certain Characters in a excel 2010 cell • How do I change a single value in a data.frame? • Set value for particular cell in pandas DataFrame using index • Copying the cell value preserving the formatting from one cell to another in excel using VBA • How to get html table td cell value by JavaScript?