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
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