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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)
 
Back
Top