Microsoft Excel has a feature called "text in columns" that you can use to separate values if they are separated by commas or semicolons. This functionality in Excel is a powerful tool that allows users to split a single column of text into multiple columns and is especially useful when combining different data into a single column. Below you will find a step-by-step guide on how to use the Text to Columns functionality in Excel in the context of Scantrust.
For Windows and Microsoft Office 2019
1. Open Microsoft Excel.
2. If the file is a CSV, select column A, completely:
3. Then click the "Data" tab and in the Data Tools group, click the Text to Columns option:
4. The following dialog box appears. Choose: Delimited and click Next:
5. Select the delimiter, which in most cases is a comma or semicolon (comma, semicolon). Then click Next.
6. Select "General" as the data format and click finish:
Use- This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different checkboxes. Get a live preview of how your data will be separated.
7. Finally, don't forget to save the updates.
For macOS
1. Open Microsoft Excel.
2. Select column A, completely.
3. Then click the "Data" tab and select the "Text to Columns" option, as follows:
4. Follow the same steps described for the Windows option.
Comments