Have you looked at the advanced filter? Using a criteria range, you can type in text that matches the start of your data, then filter to restrict the view to only matching records.