| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get SQL data to show CRLF instead of question marks?
When I query my SQL database from Excel (currently 2007) I have some fields
that have carriage-return-line-feed characters and tab characters. These show as square question marks. How can I make the CRLF and TAB characters show up properly (without having to manually edit 5000 rows)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show text instead of hash marks | Excel Discussion (Misc queries) | |||
| Show formatting marks | Excel Discussion (Misc queries) | |||
| show or hide formatting marks | Excel Worksheet Functions | |||
| Show hash marks instead of text | Excel Worksheet Functions | |||
| Finding and deleting question marks | Excel Discussion (Misc queries) | |||
Threaded Mode
