MS Excel

From Rohidekar

Jump to: navigation, search


Separate text across cells

Select the range of cells that contains the text values.

The range can be any number of rows tall, but no more than one column wide.

On the Data menu, click Text to Columns.

Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into columns.

Personal tools