Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for Employee Names
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for Employee Names
Did you try using text to columns wizard? (Data/text to columns)? If there
are any delimiters it can help . -- Greatly appreciated Eva "DaveMoore" wrote: 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 . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search for Employee Names
Post some representative examples of the cell contents.
Gord Dibben MS Excel MVP On Wed, 6 Jan 2010 10:37:57 -0800 (PST), DaveMoore wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for names | Excel Discussion (Misc queries) | |||
Compare & align 2 cols of Employee Names in sorted alpha order withVBA | Excel Discussion (Misc queries) | |||
Employee Names in Capital Letters | Excel Discussion (Misc queries) | |||
Calculate employee hours for employee evaluation? | Excel Worksheet Functions | |||
Totals sheet - deal with employee names | Excel Worksheet Functions |