Link to home
Create AccountLog in
Avatar of jimcrint
jimcrint

asked on

Excel 2007 - How to check a cell contains a value

Hi, I am trying to figure out how to check for a specific string from the active cell and place that string in a seperate cell.
I have four columns Region, City, Suburb and Address.  The addresses were imported from an external csv file and and had all this info only in the Address column (e.g. Shop 5, Addington Mall 300 Lincoln Rd Addington Christchurch).  What I would like to do is search each cell (there are 18000+) and if the word Addington exists in that cell then populate the Suburb column (on the same Row) with Addington.

TIA
ASKER CERTIFIED SOLUTION
Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Ah yes, missing parenthesis :)
Another approach:

=if(iserror(FIND("Addington",A2)),"","Addington")

Dave
Avatar of yanjieeee
yanjieeee

use asterisk wildcard * and ?
=IF(ISNUMBER(SEARCH("*vi?b*",A96)),"OK", "Not OK")
(NFP)
Note that FIND is case sensitive, so you may want to use SEARCH instead.