help with a wildcard search

B

Billy Craig

i want to search a cell that has data values such as 2301, 2303, 1101 and
place in another cell a location. all values that end in 01 would be
Gainesville as an example. I just can not remember how to wildcard for the
01 search.
this is what I am have tried:
=IF(B3=??01,"Gainesville","not gainesville")
 
P

Pete_UK

You can do it like this:

=IF(RIGHT(B3,2)="01","Gainesville","not gainesville")

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I search without wildcards? 8
Excel Wildcard in Excel array formula 0
"Find" a wildcard as a place marker and "replace" with original va 1
Replacing using a wildcard 2
Date formating yymm 2
Use of Wildcard characters with replace 2
Excel Query setup 0
Use a wildcard within edit/replace 4

Top