The content of the first cell in a range is: “ben;smith;[email protected];11/09/2020;y;y”. Other data records follow with similar format. What character would you identify when you use the text to columns function to separate the name, last name, etc?

(A) Comma

(B) Tab

(C) Semi-colon

(D) Fixed field width


The different data is separated by a semi-colon. In this scenario, semi-colons indicate the breaks between data fields and should be used to format the text to columns.


This question is from the Quiz section of the first lesson “Working with Data in Excel” from the HubSpot Excel for Marketers course. You can find answers to all the quiz questions asked in this course on our HubSpot Excel for Marketers Lesson Quiz Answers page.

Leave a Comment

Share via
Copy link
Powered by Social Snap