Special ticket qr code scanning is the result: 01,04,011001800211,65651348,1105.46, 20180709059367700785801, 6 C62D, bother to ask how to put out the values inside the cell, thank you, in execl, before=TRIM (MID (SUBSTITUTE ($A2, ", ", REPT (20) ", "), the COLUMN (A2) * 20-19, 20)) also unreliable, but feel difficulty, teachers think of way to help

CodePudding user response:

If you can, data. In the simplest respectively

CodePudding user response:

Just want to enter a display a

CodePudding user response:

It is easy to implement, but don't know what you want to press the specific rules,
Combined with sweeping code gun input, you can use VBA to realize automatic sweep a parse a, this code as long as can Resolve replaced with your rules,

 Private Sub Worksheet_Change (ByVal Target As Range) 
Dim row As an Integer, col As Integer 
The row=Target. Row 
Col=Target. The Column 
If col=1 Then Resolve Cells (the row, col), the row 
End Sub 

Private Sub Resolve (value As a String, the row As an Integer) 
Dim arr () As String 
Arr=Split (value, ", ") 
For I=1 To 8 
Cells (row, 1 + I)="'" + arr (I - 1) 
Next 
End Sub 

CodePudding user response:

Your formula, replace the comma is Chinese, but your data is a comma in English, maybe this is the reason why you formula did not get the expected result

CodePudding user response:

Not exactly this reason, I then scan the formula, it should be swamped the columns with plenty of space for the data, and then extracted to erase the leading and trailing Spaces, and then replace with how many Spaces to separator is a problem, especially the columns is not the same as the number of characters and even difference is very big, under the simple simulation will know that, if a total of n column data, the most multibit data for a, but at least it is n * in the formula a, 19 also to adjust for n * a - 1, of course, the most in the top of this value can be reduced but for simple meter calculate, this value can be increased in order to insurance, but 19 to 20 and coordinated adjustment, so the data of the building Lord, modified the half Angle Angle problem, all 20/19 set is far not enough,

CodePudding user response:

The content kao to save in the notepad, the file extension by. TXT to. CSV, under then double-click to open the file open,