I have many rows of data, similar to the {" CONDITION ": [{" JGXKZH" : "4101002", "LXR" : "pei-lin zhao"}]} then how do I use excle quickly modify the format of each line each row at the beginning of {deleted and then add a} in the content the end and then remove the content inside of [] to steps for great god teach

CodePudding user response:

In MID intercept string, replace with SUBSTITUTE

CodePudding user response:

Is to replace these characters? Or the key characters between content also clear? Can try ranked first, according to your specified characters respectively, and then list need together