Multiple records per row
Hi
It looks like there are line feeds in the data, and format is et to wrap
text.
Try Find and Replace (Ctrl +H)
Find Char(10)
Replace leave blank
If that doesn't work, in a spare column try
=SUBSTITUTE(A1,Char(10),"")
and see if your
b
b
b
becomes bbb
If so, repeat this for all three columns and copy down, then copy the 3
columns and Paste SpecialValues to "fix" the data.
Carry out your filter on this revised set of data.
--
Regards
Roger Govier
"timg" wrote in message
...
I would like to use the autofilter function on an imported database.
Unfortunately I don't have the ability to alter the database until
after I
import it into Excel. The problem I have is that some of the columns
have
more than one record per excel row. For example:
1 2 3
---------------
a b c
d
---------------
e b g
---------------
a b c
b
b
----------------
s f h
---------------
The '----" denote excel rows. The "1,2,3" denote excel column
headers. Any
ideas on how to proceed?
--
Regards, timg.
|