Video Use Text To Columns Wizard. Select the Delimiters for your data. The Text to columns function in Excel is useful.
I am calculating means and SDs for each data set so it would be useful to use the same cells that would automatically convert text to columns with average and SD functions underneath. 02032005 03032005 04032005 05032005 However if I use. Select the Delimiters for your data.
Im using Convert Text to Columns Wizard to import columns with numbers from Pages.
Select the range with full names. Found on the Data ribbon you can either specify delimiters for example you might specify a space as a delimiter to split a UK postcode into its two halves or you can click on the positions at which the data should be split based on each field. For example Comma and Space. Next go to DATA Data Tools Text to Columns.