Scribd
Upload
156 views7 pages

Text To Columns Exercise

The document provides instructions for splitting a column into multiple columns in Excel, converting American dates to European formats, and changing numerical values to text. It includes step-by-step solutions for each task, detailing the necessary actions to achieve the desired results. The document emphasizes the use of the 'Text to Columns' feature in Excel for data manipulation.

Uploaded by

Rohit Shukla
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
156 views7 pages

Text To Columns Exercise

The document provides instructions for splitting a column into multiple columns in Excel, converting American dates to European formats, and changing numerical values to text. It includes step-by-step solutions for each task, detailing the necessary actions to achieve the desired results. The document emphasizes the use of the 'Text to Columns' feature in Excel for data manipulation.

Uploaded by

Rohit Shukla
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

1.

Split the following column to columns: All rights reservered:


[Link]
Name Age Favorite Color
Dan 33 Yellow
Gil 27 Red
Tom 33 Blue
Sammy 28 Black
Sharon 22 Pink

2. Convert the American Dates to European Dates:

Date
5/20/2015
3/15/2017
4/16/2016
9/30/2015
4/5/2017

3. Convert the following values from numbers to text:

ID Is it text?
3435 1
3245 1
2346 1
5635 1
[Link] the following column to columns: All rights reservered:
[Link]
Name~Age~Favorite Color
Dan~33~Yellow
Gil~27~Red
Tom~33~Blue
Sammy~28~Black
Sharon~22~Pink

Solution:

Name Age Favorite Color


Dan 33 Yellow
Gil 27 Red
Tom 33 Blue
Sammy 28 Black
Sharon 22 Pink

Select the cells you want to split to columns:

Go to Data ribbon and click Text to Columns:

Select Delimited and click "Next":


Type the ~ (Tilde) Delimiter in "Other" and click "Finish"

2. Convert the American Dates to European Dates:

Date
5/20/15
3/15/17
4/16/2016
9/30/2015
5/4/2017

Solution:

Date
5/20/2015
3/15/2017
4/16/2016
9/30/2015
4/5/2017

Select the relevant cells, then click "Text to Columns" and choose "Delimited".
Do not select any delimiter and click "Next"

Select "Date" and choose the current date format - MDY and click "Finish"
3. Convert the following values from numbers to text:

ID Is it text?
3435 0
3245 0
2346 0
5635 0

Solution:

ID Is it text?
3435 1
3245 1
2346 1
5635 1

Select the relevant cells, then click "Text to Columns" and choose "Delimited".
In Step 2, Do not select any delimiter and click "Next"
In Step 3, Choose "Text" in Column data format:

You might also like