| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I replace a carrige control(box) in excel using VB
I am using Excel to query an Access database. The query is pulling in a memo
field from Access. Excel is displaying the carriage control "chr(13)" as a box. I can do a find replace using "chr(13)" changing it to a space until I hit a cell that has to much data in it. I am getting a "formula too long" error. Is there a way to use VB code to address this issue and replace this "box"? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| difference between Alt-Control-Shift-F9 and Ctrl-H Replace = with | Excel Discussion (Misc queries) | |||
| Excel spin box - no Control tab in Format Control dialong box | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Calendar Control: Can't exit design mode because control can't be created | Excel Programming | |||
Threaded Mode
