Search for Employee Names

  • Thread starter Thread starter DaveMoore
  • Start date Start date
D

DaveMoore

Good Evening.
My spreadsheet contains data imported from an Oracle database. This
data is in text form in a single column and can run to many thousands
of rows. The data itself is a mix of numeric and alphabetical
characters, The string in each cell of varying lengths.
I need to find employee names contained within each text string. If
there were just one or two names to find I would either use 'FIND' or
use 'filter - contains' but there are hundreds!
Has anyone any ideas how I might tackle this problem?

My thanks for any responses.
Dave Moore
 
Did you try using text to columns wizard? (Data/text to columns)? If there
are any delimiters it can help .
 
Post some representative examples of the cell contents.


Gord Dibben MS Excel MVP
 
Back
Top