Treat Quotations as text?

[sjbayer3]

I am importing large amounts of data from a CSV file into excel in the following format:
Column 1 contains text, columns 2-20 contain data specific(for each row) to the text in column 1.

Some of the text in column 1 begins with quotations such as:

"radiant wood"
radiant wood
[radiant wood]

Here is the issue:

Because excel removes the quotations, my vlookup command is mixing the phrases with quotations with the phrases that do not contain quotations.

Is there any way to fix this?

Thank you much!

 

[pgc01]

Hi

Try the following

- change the extension of the csv file to txt
- open the txt file, you'll be taken to the Text to Columns Dialog
1. in the first panel choose Delimited and press next
2. in the second panel uncheck all delimiters except comma.
3. the Text Qualifier is by default the double quote. Change it to {none}
4. Press Finish

This should keep the quotes when you open the file.

Please test.

 

[sjbayer3]

Nailed it, thank you very much!