Mid Excel nested function how to keep the
CodePudding user response:
Can see first=mid (a8, 4, 1) what is returned, should not 1, it is you see in the 13... What there are things before, click on the edit box A8 to look at it, in addition, the instructions say is 01 for Beijing, said the two yards, then don't use one, though you no problem here,
CodePudding user response:
reference 1/f, zara's reply: can see=mid (a8, 4, 1) what is returned, should not 1, it is you see in the 13... What there are things before, click on the edit box A8 to look at it, in addition, the instructions say is 01 for Beijing, said the two yards, then don't use one, though you is right, CodePudding user response:
reference 1/f, zara's reply: can see=mid (a8, 4, 1) what is returned, should not 1, it is you see in the 13... What there are things before, click on the edit box A8 to look at it, in addition, the instructions say is 01 for Beijing, said the two yards, then don't use one, though you is right, CodePudding user response:
01 and 02 to also want to add double quotation marks, strictly speaking, should be to determine 03, to prevent invalid or new city; Put it that way, I'm afraid to establish a "code - city" list, and then to query more reliable also facilitate the expansion of the future, CodePudding user response:
Zara refer to 4th floor response: 01 and 02 will add double quotation marks, strictly speaking, should be to determine 03, to prevent invalid or new city; Put it that way, I'm afraid to establish a "code - city" list, and then to query more reliable also facilitate the expansion of the future, 
