Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have imported data from a database.
One column contains comments which might include words such as:- store compound laundry If one of the above words is included in the text cell I would like to assign a code to it in an adjacent column, i.e. store A compound B laundry C Is this possible thanks Newberry -- Remove DOG from address |
#2
![]() |
|||
|
|||
![]()
Try
=IF(ISNUMBER(SEARCH("store",A1),"A","") change SEARCH to FIND to make it case sensitive. "Newberry" wrote in message ... I have imported data from a database. One column contains comments which might include words such as:- store compound laundry If one of the above words is included in the text cell I would like to assign a code to it in an adjacent column, i.e. store A compound B laundry C Is this possible thanks Newberry -- Remove DOG from address |
#3
![]() |
|||
|
|||
![]()
Dave,
thanks for taking the time to reply. When I enter your formula I get an error, I think one of the closing brackets is missing from the formula but I'm not able to correct it. Newberry "Dave R." wrote in message ... Try =IF(ISNUMBER(SEARCH("store",A1),"A","") change SEARCH to FIND to make it case sensitive. "Newberry" wrote in message ... I have imported data from a database. One column contains comments which might include words such as:- store compound laundry If one of the above words is included in the text cell I would like to assign a code to it in an adjacent column, i.e. store A compound B laundry C Is this possible thanks Newberry -- Remove DOG from address |
#4
![]() |
|||
|
|||
![]()
Following up my previous post, the following works for me,
=IF(ISNUMBER(SEARCH("store",A1)),"A",""). I added a second close bracket after the cell reference Newberry "Newberry" wrote in message ... Dave, thanks for taking the time to reply. When I enter your formula I get an error, I think one of the closing brackets is missing from the formula but I'm not able to correct it. Newberry "Dave R." wrote in message ... Try =IF(ISNUMBER(SEARCH("store",A1),"A","") change SEARCH to FIND to make it case sensitive. "Newberry" wrote in message ... I have imported data from a database. One column contains comments which might include words such as:- store compound laundry If one of the above words is included in the text cell I would like to assign a code to it in an adjacent column, i.e. store A compound B laundry C Is this possible thanks Newberry -- Remove DOG from address |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I search for words in all caps in Excel? | Excel Discussion (Misc queries) | |||
How can I search for words in all caps in Excel? | Excel Discussion (Misc queries) | |||
Search for multiple words | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) | |||
better search: "make worksheet visible" | Excel Discussion (Misc queries) |