If function

Posted by Anthony on August 21, 2001 10:36 AM

Hello. In cell A1 I have a description of a product with either the state spelled out or abbreviated (California or CA). In cell A2 I would like to write a formula that would place the state inside cell A2. I've tried using the If function but can't seem to get it to work. Any suggestions?

Thanks

Anthony

Posted by Aladin Akyurek on August 21, 2001 10:49 AM

Anthony,

Give some examples of product descriptions which apparently contains the state.

Aladin

Posted by Anthony on August 21, 2001 11:00 AM

Hello Aladin! Thanks for the response. Here is an example:

SPANMATH2002 GR 1 SPANISH MATHEMATICS CALIFORNIA PUPILS EDITION (CONSUMABLE)

Thanks Anthony

Posted by Aladin Akyurek on August 21, 2001 11:22 AM

It's a VBA question

I suspected something like this. I believe you need a task-specific VBA code that is capable of searching each item from a state (including abbrevs) list in a given string that produces the state or abbrev substring that it finds. So, you need a VBA programmer.

Aladin

Posted by Anthony on August 21, 2001 12:00 PM

Re: It's a VBA question

Thanks for the advice!

Anthony