Megan is currently working in a text file that contains a space as a delimiter. She is concerned because proper names, such as Alice Brown, should be considered one value, not two. How should these values appear in the text file to avoid being separated into two values when imported into Excel^®? A) They should be surrounded by double quotes, as in "Alice Brown." B) There should be no space between proper names, as in "AliceBrown." C) The import wizard automatically knows these proper names are one value. D) They should be eliminated from the text file.

Question

Quizplus · Accepted Answer

Surrounding proper names with double quotes will indicate to the import wizard that they should be considered as one value and not be separated into two values based on the space delimiter.

Megan Is Currently Working in a Text File That Contains