Forum Discussion
Automatic Text To Column for Multiple Column
Hello Everyone, I need to find a way to use text to column feature for multiple column for a table before I use that excel book for another macro enabled excel book. I am adding the table as...
Hi ArdaOzguler
Alternatively with Power Query:
- Select all data
- From Home tab > Format as Table
- From Data tab > icon From Table/Range (Power Query Editor opens)
- Icon Close & Load (top left in the toolbar)
Sample attached