C
carolmcg
Hi
We have imported a text file into Excel which put it into one column.
The original data was all in one field in the source system. We the
used text to columns to split data and data has split into separat
rows and columns but now we want to sort and find all records with an
in one of the fields. As all the fields are in different columns due t
the length of the original data being so varied, we cannot get th
result we want!
Any assistance would be greatly appreciated.
We did try to use filtering but there are hundreds of columns and row
and when you filter on one column, you do not see the rest of the dat
:confused
We have imported a text file into Excel which put it into one column.
The original data was all in one field in the source system. We the
used text to columns to split data and data has split into separat
rows and columns but now we want to sort and find all records with an
in one of the fields. As all the fields are in different columns due t
the length of the original data being so varied, we cannot get th
result we want!
Any assistance would be greatly appreciated.
We did try to use filtering but there are hundreds of columns and row
and when you filter on one column, you do not see the rest of the dat
:confused