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 the proper names with double quotes tells Excel to treat the entire string as one value, even if it contains spaces. This is a common way to handle data with spaces as delimiters.

Megan Is Currently Working in a Text File That Contains