<div>
For reference, you could also do it with a formula:<br />
<br />
For the first column:<br />
=LEFT(RIGHT(A1,LEN(A1)-2),<wbr />LEN(A1)-3)<wbr /><br />
For the other two columns:<br />
=LEFT(RIGHT(A1,LEN(A1)-1),<wbr />LEN(A1)-2)<wbr /><br />
<br />
You could put these formulas at the top of a new column and drag down to get the correct results for all cells in column A.
</div>


For reference, you could also do it with a formula:

For the first column:
=LEFT(RIGHT(A1,LEN(A1)-2),LEN(A1)-3)
For the other two columns:
=LEFT(RIGHT(A1,LEN(A1)-1),LEN(A1)-2)

You could put these formulas at the top of a new column and drag down to get the correct results for all cells in column A.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
How can I remove symbols surrounding text ('text' or 'text' from all entries in a column in excel - I'm using Excel 2011 Mac<br />
<br />
Hope this is really easy but I'm not familiar with excel - I have 3 columns of data - first starts ('text' second and third each start with 'text'<br />
<br />
thanks
</div>
</div>


Hi

How can I remove symbols surrounding text ('text' or 'text' from all entries in a column in excel - I'm using Excel 2011 Mac

Hope this is really easy but I'm not familiar with excel - I have 3 columns of data - first starts ('text' second and third each start with 'text'

thanks

how can I remove symbols ( and ' from excel data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.