How can you split a column into 2 or more columns?

آپ ایک کالم کو 2 یا زیادہ کالموں میں کیسے تقسیم کر سکتے ہیں؟

Select the cell that you want to split. Then, navigate to the Home Tab, after that, select Text to Column.

Select the cell that you want to split. Then, navigate to the Insert Tab, after that, select Text to Column.

Select the cell that you want to split. Then, navigate to the Design Tab, after that, select Text to Column.

Select the cell that you want to split. Then, navigate to the Data Tab, after that, select Text to Column.

Select the "Sales Rep" column, and then select Home > Transform > Split Column.

Split data into multiple columns

Select the "Sales Rep" column, and then select Home > Transform > Split Column.
Select Choose the By Delimiter.
Select the default Each occurrence of the delimiter option, and then select OK. ...
To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".