RAMCO online computer training
RAMCO software training schedule
RAMCO software public training
RAMCO software training private
RAMCO software training online classes
What is online training?
RAMCO software training online class schedule
RAMCO software training specials
RAMCO software help keys
RAMCO training courseware
RAMCO student downloads files
RAMCO software training
RAMCO software training locations
RAMCO computer training contact information

 

 

 

 

Computer Training Help! Key

 

Excel 2013: Create a new column using data from another column (Text to Columns).

STEPS

Use text from an existing column to create a new column.

  • Select a column containing the text you want to separate.

  • From the Data tab, Data Tools group,
    Click: Text to Columns
    Select: Delimited file type
    Click: Next
    Select: The type of Delimiter you want to use
    (the Delimeter "Space" was used in our example)
    Click: Next
    Select: Column data format
    Choose: Destination for new columns
    Click: Finish

  • Rename: column headings

  • Size: column widths (if necessary)