| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hard line break displaying as rectangle on import from SQL
Hi,
Am pulling data from a company db via SQL and the hard line breaks in several fields are coming is as that annoying little rectangle. Result is that the report is pages and pages longer than it has to be. When try to use the Replace function, Excel does not recognize the character. Any ideas on how to control this short of going through the entire data set manually? Thanks much for any ideas, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I insert a hard break (alt enter) in a concatenated string | Excel Discussion (Misc queries) | |||
| Replacing a hard line break in Excel | Excel Discussion (Misc queries) | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| line break / hard return? | Excel Discussion (Misc queries) | |||
| Hard Page Break | Excel Worksheet Functions | |||
Threaded Mode
