Search for Employee Names

[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

 

[Eva]

Did you try using text to columns wizard? (Data/text to columns)? If there
are any delimiters it can help .

 

[Gord Dibben]

Post some representative examples of the cell contents.


Gord Dibben MS Excel MVP