Search for Employee Names

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
 
E

Eva

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

Gord Dibben

Post some representative examples of the cell contents.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top