| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on Linefeeds/Carriage returns
You've got replies at your other post.
Dan wrote: Hi! I have a problem that I hope someone will be able to help me with. I have an Access table that I exported to Excel. Some of the data has linfeeds in them between small paragraphs. For some reason, it displays the linefeeds as single heavy vertical bars. I understand Access and Excel treat linefeeds differently (Excel uses CHR(10) and Access uses CHR(10) & CHR(13)). The funny thing is, it displays the linefeed correctly in the address bar. Then, when I click anywhere in the address bar of one of the suspect cells and then press enter, it displays the linefeed correctly in the cell. Any help would be greatly appreciated. Thanks a lot! Dan -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i hide carriage returns? | Excel Discussion (Misc queries) | |||
| Carriage returns - how to get rid of them (again) | Excel Discussion (Misc queries) | |||
| Formula for Carriage Returns | Excel Discussion (Misc queries) | |||
| Carriage returns | Excel Discussion (Misc queries) | |||
| Replacing Carriage Returns | Excel Programming | |||
![Dave Peterson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
