Fill the column State_name in the worksheet Consumer_Complaints with the data from the State_Code_Name worksheet

[SHIVANISHARMA1711]

Src					STATE	CODE
{ "STATE": "Alabama", "CODE": "AL"}			Alabama	AL
{ "STATE": "Alaska", "CODE": "AK"}			Alaska	AK
{ "STATE": "Arizona", "CODE": "AZ"}			Arizona	AZ
{ "STATE": "Arkansas", "CODE": "AR"}			Arkansas	AR
{ "STATE": "California", "CODE": "CA"}			California	CA
{ "STATE": "Colorado", "CODE": "CO"}			Colorado	CO
{ "STATE": "Connecticut", "CODE": "CT"}			Connecticut	CT
{ "STATE": "Delaware", "CODE": "DE"}			Delaware	DE
{ "STATE": "District of Columbia", "CODE": "DC"}		District of Columbia	DC
{ "STATE": "Florida", "CODE": "FL"}			Florida	FL
{ "STATE": "Georgia", "CODE": "GA"}			Georgia	GA
{ "STATE": "Hawaii", "CODE": "HI"}			Hawaii	HI
{ "STATE": "Idaho", "CODE": "ID"}			Idaho	ID
{ "STATE": "Illinois", "CODE": "IL"}			Illinois	IL
{ "STATE": "Indiana", "CODE": "IN"}			Indiana	IN
{ "STATE": "Iowa", "CODE": "IA"}			Iowa	IA
{ "STATE": "Kansas", "CODE": "KS"}			Kansas	KS
{ "STATE": "Kentucky", "CODE": "KY"}			Kentucky	KY
{ "STATE": "Louisiana", "CODE": "LA"}			Louisiana	LA
{ "STATE": "Maine", "CODE": "ME"}			Maine	ME
{ "STATE": "Montana", "CODE": "MT"}			Montana	MT
{ "STATE": "Nebraska", "CODE": "NE"}			Nebraska	NE
{ "STATE": "Nevada", "CODE": "NV"}			Nevada	NV
{ "STATE": "New Hampshire", "CODE": "NH"}		New Hampshire	NH

 

[hagia_sofia]

Hello, and what exactly is the goal here? To split those text strings (e.g. { "STATE": "Alabama", "CODE": "AL"}) via formula into columns STATE and CODE or something else?

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1
2	{ "STATE": "Alabama", "CODE": "AL"}	Alabama	AL
3	{ "STATE": "Alaska", "CODE": "AK"}	Alaska	AK
4	{ "STATE": "Arizona", "CODE": "AZ"}	Arizona	AZ
5	{ "STATE": "Arkansas", "CODE": "AR"}	Arkansas	AR
6	{ "STATE": "California", "CODE": "CA"}	California	CA
7	{ "STATE": "Colorado", "CODE": "CO"}	Colorado	CO
8	{ "STATE": "Connecticut", "CODE": "CT"}	Connecticut	CT
9	{ "STATE": "Delaware", "CODE": "DE"}	Delaware	DE
10	{ "STATE": "District of Columbia", "CODE": "DC"}	District of Columbia	DC
11	{ "STATE": "Florida", "CODE": "FL"}	Florida	FL
12	{ "STATE": "Georgia", "CODE": "GA"}	Georgia	GA
13	{ "STATE": "Hawaii", "CODE": "HI"}	Hawaii	HI
14	{ "STATE": "Idaho", "CODE": "ID"}	Idaho	ID
15	{ "STATE": "Illinois", "CODE": "IL"}	Illinois	IL
16	{ "STATE": "Indiana", "CODE": "IN"}	Indiana	IN
17	{ "STATE": "Iowa", "CODE": "IA"}	Iowa	IA
18	{ "STATE": "Kansas", "CODE": "KS"}	Kansas	KS
19	{ "STATE": "Kentucky", "CODE": "KY"}	Kentucky	KY
20	{ "STATE": "Louisiana", "CODE": "LA"}	Louisiana	LA
21	{ "STATE": "Maine", "CODE": "ME"}	Maine	ME
22	{ "STATE": "Montana", "CODE": "MT"}	Montana	MT
23	{ "STATE": "Nebraska", "CODE": "NE"}	Nebraska	NE
24	{ "STATE": "Nevada", "CODE": "NV"}	Nevada	NV
25	{ "STATE": "New Hampshire", "CODE": "NH"}	New Hampshire	NH
Data

Cell Formulas
Range	Formula
B2:C25	B2	=CHOOSECOLS(TEXTSPLIT(A2,""""),4,8)
Dynamic array formulas.

 

[SHIVANISHARMA1711]

I HAVE THESE COUNTRY NAME AND CODE IN ONE SHEET AND I HAVE TO TRANSFER THESE NAME OF COUNTRIES IN ANOTHER WORKSHEET WHICH HAVE CODE OF COUNTRY. SO BASICALLY I HAVE TO TRANSFER NAME OF COUNTRY MATCHES WITH COUNTRY CODE.

 

[Fluff]

Please do not post in capitals, it is considered to be shouting & therefore rude.

Can you post a sample of the output sheet with expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.