How do I remove charaters or split up a column in excel?
Posted on 2010-11-16
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
(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.