Text to Columns Examples
Text2Column Ex 3
Use a tool to split column A into 4 columns being the Branch, bank account number, surname and salary.
Note that the bank account number must keep the leading zero and have all its numbers.
To see the full course contents click here.