Covert state name in Two letters by using formula(not use in split formula)

[Regila]

Hi,
In state name contains mixed states in one cell. I need result like expected o/p cell . Based upon the state name and state code on

States Name

Expected O/P

California

CA

Arizona, California, Connecticut, Florida, Nevada, New York

CA,CT,FL,NV,NY

Arizona

AZ

Colorado

CO

Connecticut

CT

Nevada

NV

New York

NY

Ohio

OH

New Hampshire

NH

Connecticut

CT

Florida

FL

California

CA

 

[kweaver]

What's wrong with using the SPLIT function?

 

[Regila]

What's wrong with using the SPLIT function?

Nothing wrong. But I am trying some other fuction or script.

 

[Regila]

Nothing wrong. But I am trying some other fuction or script.

That's my task. Not using split function I need to develop my project.

 

[kweaver]

Sounds like a test or homework.

 

[Regila]

Sounds like a test or homework.

This is one of the my project part. Once I will done this part means after that only I will move on next part of my projects

 

[kweaver]

I don't believe helpers in here do someone's test or homework or assignments.