As shown,
Problem: the left form character sequence can't move, and then in the right circle is containing names + digital data, and then replace to the left in the table, novice, a great god give a steps thanks a lot

CodePudding user response:

1, separate the right name + number, use function mid and right
2, using vlookup function, on the left with the name on the form matches separate form on the right