• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 119
  • Last Modified:

Excel wild card in formula

hello,

my data is like this    i want to put in B2  a formula that triggers, if cell in column A starts with a star * then put nothing if does not start with * then put 1


Column A
*Product*
Prod
Fabc
0
Flora
Asked:
Flora
3 Solutions
 
ProfessorJimJamCommented:
=IF(LEFT(J9,1)="*","",1)
0
 
Rgonzo1971Commented:
Hi,

pls try

=IF(LEFT(A2)="*","","1")

Regards
0
 
Rob HensonFinance AnalystCommented:
* is normally recognised as Wild Card for anything, try referring to the ASCII code for * instead, code 42, eg:


A2 = *PRODUCT*
=IF(LEFT(A2,1)=CHAR(42),"TRUE","FALSE")

Thanks
Rob H
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rgonzo1971Commented:
Then it should be

=IF(LEFT(A2)=CHAR(42),"","1")

Regards
0
 
Rory ArchibaldCommented:
The equality operator doesn't recognise wildcards so a simple ="*" test is fine.
0
 
FloraAuthor Commented:
Thank you guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now