| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search For Common Text in Column
I am trying to search for specific words in column A and then print an
abbrviated version of those specific words in Column B. There is a set of 7 words that I want to search for and if one is found i want to print the abbreviated word if not I want to move to the next word I am searching for. I have been trying to use the If, Lookup and search functions. I have not been successful. Example with 2 of the words I am searching for. I want this to be one string so I can just place in column B. =IF(SEARCH("Functional",A4),"Fs",IF(SEARCH("Techni cal",A4),"ts") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find common text in cell in column in sheet then return total amou | Excel Worksheet Functions | |||
| search a column for last instance of text | Excel Discussion (Misc queries) | |||
| Combine 2 spreadsheets w/1 common column of data, text and number | Excel Worksheet Functions | |||
| Can you search for common results in many wrksheets? | Excel Worksheet Functions | |||
| search multiple worksheets name with common text and process using | Excel Worksheet Functions | |||
Threaded Mode
