Help with regex recognition in Excel

[yaz282]

I have a dataset that was created in google docs spreadsheet with a number of regex queries applied to the data. The set has been transferred to an Excel workbook and all outcomes are showing as #NAME rather than a 0,1 coding as they should for the outcome to the work. I don't have access to the google docs work but i'm wondering what do I need to active/do in Excel for the output to show in the same way? I'm new to Regex so not sure what to do.
Any help would be much appreciated.

 

[JoeMo]

Can you provide an example or two of the input to Excel that generates the #NAME output?

 

[yaz282]

Can you provide an example or two of the input to Excel that generates the #NAME output?

Sure!

I've got
=IF(REGEXMATCH($G2,"([[Ss]ugar|[Ss]yrup)"),1,0) which shows up as #name.

The cell it was referencing contained hte folllowing sting so the result should be 1.

wheat flour, grains (36%) (wheat meal, kibbled purple wheat, kibbled red wheat), vegetable oil (sunflower oil), bran, salt, sunflower seeds, sesame seeds, rock salt (0.5%), raising agent (500), yeast, milk solids, sugar

<colgroup><col width="626"></colgroup><tbody>
</tbody>

 

[JoeMo]

Sure!

I've got
=IF(REGEXMATCH($G2,"([[Ss]ugar|[Ss]yrup)"),1,0) which shows up as #name.

The cell it was referencing contained hte folllowing sting so the result should be 1.

wheat flour, grains (36%) (wheat meal, kibbled purple wheat, kibbled red wheat), vegetable oil (sunflower oil), bran, salt, sunflower seeds, sesame seeds, rock salt (0.5%), raising agent (500), yeast, milk solids, sugar

<tbody>
</tbody>

There is no worksheet function in Excel named REGEXMATCH, so using it in a formula causes Excel to respond with #NAME indicating thr function name is not recognized. A user-defined function (UDF) could be written using VBA to provide that function in Excel, or perhaps one already exists (Google Excel UDF for Regex match).