I receive a data base by .csv and use excel to extract the fields I need.
Some of the data in not needed and gets in the way. There are way to many to
"unselect" in sort. Is there a way I can create a table to use only the data
I need or don't need?

When you say you want to "create a table...", exactly what do you want to
do? Delete some columns? Delete some rows? How would you identify what
you want to delete? Do you have a list of what you want to keep? Or a list
of what you don't want to keep? Please post back and clarify what you want
to do. HTH Otto
"asg2307" wrote in message
...
I receive a data base by .csv and use excel to extract the fields I need.
Some of the data in not needed and gets in the way. There are way to many
to
"unselect" in sort. Is there a way I can create a table to use only the
data
I need or don't need?

If your source file was renamed to source.txt instead of source.csv
then when you try to open it in Excel you will be taken through the
Data Import Wizard. In the third panel of this you can select column(s)
to SKIP, i.e. do not import into Excel, so you could just leave them
out this way.

Pete

Say I have data that contain cat, dog, fish, bird. Each of those data will
look like cat12, cat23, dog11, fish43, fish54, fish78, etc. I want only
cat##, and dog##, no fish or bird. They are all in the same column. That is
what I mean.

"Otto Moehrbach" wrote:

When you say you want to "create a table...", exactly what do you want to
do? Delete some columns? Delete some rows? How would you identify what
you want to delete? Do you have a list of what you want to keep? Or a list
of what you don't want to keep? Please post back and clarify what you want
to do. HTH Otto
"asg2307" wrote in message
...
I receive a data base by .csv and use excel to extract the fields I need.
Some of the data in not needed and gets in the way. There are way to many
to
"unselect" in sort. Is there a way I can create a table to use only the
data
I need or don't need?

I understand now what you want. You want to clear all entries in that
column that do not start with "cat" or "dog". That's easy enough. That
will leave a bunch of blank cells in your data. What do you want to happen
with those blank cells. Does your data have other columns? If it does, do
you want anything done with those other columns? HTH Otto
"asg2307" wrote in message
...
Say I have data that contain cat, dog, fish, bird. Each of those data
will
look like cat12, cat23, dog11, fish43, fish54, fish78, etc. I want only
cat##, and dog##, no fish or bird. They are all in the same column. That
is
what I mean.

"Otto Moehrbach" wrote:

When you say you want to "create a table...", exactly what do you want to
do? Delete some columns? Delete some rows? How would you identify what
you want to delete? Do you have a list of what you want to keep? Or a
list
of what you don't want to keep? Please post back and clarify what you
want
to do. HTH Otto
"asg2307" wrote in message
...
I receive a data base by .csv and use excel to extract the fields I
need.
Some of the data in not needed and gets in the way. There are way to
many
to
"unselect" in sort. Is there a way I can create a table to use only
the
data
I need or don't need?