Thread
:
Carriage Return in a Concatenation
View Single Post
#
5
Posted to microsoft.public.excel.newusers
[email protected]
external usenet poster
Posts: 15
Carriage Return in a Concatenation
This is working, thank you.
Gord Dibben wrote:
Carriage return is CHAR(10)
=H2 & CHAR(10) & I2 & CHAR(10) & on and on.
Gord Dibben MS Excel MVP
On 12 Aug 2006 08:02:03 -0700,
wrote:
I have a serveral lines of
VB
that I need to Concatate, I have them in
seperate columns b/c a few aspects will change. Currently my
Concatenation looks like =H2&I2&J2&K2, I need a carriage return between
&, I can get this result by putting each row colum on a seperate row,
but that is not really feasiable, I know that there has to be a better
way, any suggestions?
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]