Link to home
Start Free TrialLog in
Avatar of hankknight
hankknightFlag for Canada

asked on

Excel: If cell begins with #

How can I test if a string of content begins with "#"?

Obviously, my code below does NOT work:

=IF("#HELLO" BEGINS_WITH "#","String begins with #", "String does not begin with #")

Open in new window


I use Office 2010.
ASKER CERTIFIED SOLUTION
Avatar of Member_2_921743
Member_2_921743
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial