Column A has text that may appear as follows:
300-3000-000-000-000
300-3490-IRE-CAP-555
100A860
300-3230

I'm trying to write a formula that will return a "label" of PROJECT for all text that appears as 3**-***, etc. All others should be "labeled" SHARED or some other defining text.

Currently A1 = 300-3219-CNS
A2 = 100A860

H1 = SHARED

I've written the formula as
=IF(A1="3*","PROJECT",H1)

It returns the formula as H1 or SHARED and I want it to return PROJECT.

I've replaced the * with ?, but that doesn't seem to help. Is there a different wildcard I should use?

What am I missing - PLEASE HELP.