Here is how to format a text cell so it will have either double or single quotes. I needed to import a csv file with text fields formatted with double quotes. There are probably some more reasons why you might need to do this.
- Edit the cell or column you need to format
- choose format cell
- Select Custom from the bottom
- use the formula \"@\"
The @ symbol represents the text in the field. You can wrap any text field with any character but make sure to escape it.
9 comments:
Thank you! Needed that!
Great tip Thank you
Thank you very much!!
Very handy, thank you!
doesn't work with numbers
If you want to format both (text and numbers), use \"#\";\"@\" as format.
Source http://www.databison.com/custom-format-in-excel-how-to-format-numbers-and-text/
Thank you so much! You just saved me SO much time!
wow- works like magic
It appears to work in Excel but when I open the document in Notepad, it has double quotes instead of single. Anyone know why?
Post a Comment