How do I change the column delimiter in Excel?

Question

Answer: In Microsoft Windows, click the Start button, and then click Control Panel. Open the dialog box for changing Regional and Language settings. In the dialog box, look for the List separator setting. (Location may vary based on Windows version. . Enter the desired list separator. Click Apply and then click OK.

Can you change the delimiter in Excel?

Click File > Options > Advanced. Under Editing options, clear the Use system separators check box. Change the default Decimal separator. As this will change the way decimal numbers are displayed in your worksheets, choose a different Thousands separator to avoid confusion.

How do I change the default delimiter in Excel?

Change the default list separator for saving files as text (.1Clear Excel Options > Advanced > Editing options > Use system separators.2Set Decimal separator to , (a comma).3Set Thousands separator to . (a period).

How do I apply a different delimiter in Excel?

Try it!1Select the cell or column that contains the text you want to split.2Select Data > Text to Columns.3In the Convert Text to Columns Wizard, select Delimited > Next.4Select the Delimiters for your data. ... 5Select Next.6Select the Destination in your worksheet which is where you want the split data to appear.

How do I change delimiters in Excel Windows 10?

Windows1Open the Windows Start Menu and click Control Panel.2Open the Regional and Language Options dialog box.3Click the Regional Options tab.4Click Customize/Additional settings (Windows 10)5Type a comma into the 'List separator' box (,)6Click 'OK' twice to confirm the change.

Expert · Answer