In excell how do I format a spreadsheet w/ the categories entered.

P

Pivotal

I was given a file where the categories are all in the first column separated
by quotation marks, need to separate them into thier own colums. Any
suggestions?
 
N

Nick Hodge

Quotation marks normally denote a text entry in a fixed width or delimited
file. If this is the case, That is the quotation marks are both sides of
the field then either get rid of any file extension or rename it to *.txt.

You will then be able to use Excel's text import wizard and use another
delimiter, say space or use the fixed width option, making sure the text
identifier is "

If they genuinely are the delimiter, then select the data and go to
Data>Text to columns, select Delimited>Other and type"

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top