Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: Split Text

Split Cell Content Using Text to Columns in Excel

To separate the contents of one Excel cell into separate columns, you can use the ‘Convert Text to Columns Wizard’. For example, when you want to separate a list of full names into last and first names. 1. Select the range with full names. 2. On the Data tab, in the Data Tools group, click Text to Columns. The following dialog box appears.…