LenCepeda
asked on
How do I remove charaters or split up a column in excel?
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
you can use this formula
=MID(A2,SEARCH("|",A2)+1,9
=MID(A2,SEARCH("|",A2)+1,9
ASKER
wow thanks for the quick responses. i stepped out for lunch and you all answered my question before i got back. thanks again
Thats a neat trick :) I doubted the validity of that but it does work!
You are truly a Genius.
- Ardhendu