Text to Columns Examples

Please purchase the course before starting the lesson.

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.

Back to: Advanced Excel Course > Tools for text