Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a VB 2005 application that imports title into excel; how do I
get it to not include the carriage return symbol's this is the code: I this code is in a function and gets called for every line that needs to be included in the title heading. mSubTitle += strFilter & ": " & strSubTitle & vbCrLf I also tried this: mSubTitle += strFilter & ": " & strSubTitle + Chr(13) + Chr(10) When excel opens I get the title and at the end of every line is a small square. How do I make this work? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to find replace text or symbol with carriage return | New Users to Excel | |||
Carriage return symbol - how to split columns at | Excel Discussion (Misc queries) | |||
Importing data to excel (newline/carriage return issue) | Excel Discussion (Misc queries) | |||
symbol to represent a carriage return | Excel Worksheet Functions | |||
How do I ignore newline character/carriage return while importing | Excel Discussion (Misc queries) |