Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Concatenate a line feed
- Thread starter KKit
- Start date
- Thread starter
- #2
Sorry..a bit more info...I know that you should be putting concatenate(Line1,char(10),Line2) to get
Line1
Line2
However, my system only returns Line1 then a questionmark in a box and then Line2.
Why not do the line feed...why the question mark in a box?
Line1
Line2
However, my system only returns Line1 then a questionmark in a box and then Line2.
Why not do the line feed...why the question mark in a box?
It may be that you haven't formatted the cells as having Alignment Wrap Text on. ( Format/Cells/Alignment/Wrap Text checkbox ... or Home tab on ribbon/Alignment/Wrap Text, in 2007 )
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
- Status
Similar threads
- Question