<div>
Tracey,<br />
<br />
Thats a neat trick :) I doubted the validity of that but it does work! <br />
<br />
You are truly a Genius. <br />
<br />
- Ardhendu
</div>


<div>
you can use this formula <br />
<br />
=MID(A2,SEARCH(&quot;|&quot;,A2)+1,9<wbr />9)
</div>


<div>
wow thanks for the quick responses. &nbsp;i stepped out for lunch and you all answered my question before i got back. thanks again
</div>


<div>
<div class="content wysiwyg-content">
Hi folks, i am having a hard time with the results of a sql query. &nbsp;Basically i have a data field with two types of information combined into one field seperated by a pipe, &nbsp;the problem is a date is included in the field and i need to be able to sort and filter by this date.<br />
<br />
unfortunately saving as a csv makes a mess of everything. &nbsp;so i copy the results and paste them into an excel file but i need to separate the that one column. <br />
<br />
my data appears like this:<br />
(code letters) | 11/16/2010<br />
<br />
Example:<br />
(SG) | 11/16/2010<br />
<br />
I need to either remove the code letters all together, including the parenthesis and pipe or I need to split up the column into two columns. &nbsp;anything suggestions would help. &nbsp;<br />
<br />
<br />

</div>
</div>


Hi folks, i am having a hard time with the results of a sql query.  Basically i have a data field with two types of information combined into one field seperated by a pipe,  the problem is a date is included in the field and i need to be able to sort and filter by this date.

unfortunately saving as a csv makes a mess of everything.  so i copy the results and paste them into an excel file but i need to separate the that one column. 

my data appears like this:
(code letters) | 11/16/2010

Example:
(SG) | 11/16/2010

I need to either remove the code letters all together, including the parenthesis and pipe or I need to split up the column into two columns.  anything suggestions would help.  




How do I remove charaters or split up a column in excel?

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

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.