|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
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?
|
|
=H2&CHAR(10)&I2&CHAR(10)&J2&CHAR(10)&K2
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
<eyeman6513_2000[ at ]yahoo.com> wrote in message
news:1155394923.841114.322770[ at ]m79g2000cwm.googlegroups.com...
[Quoted Text] > 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?
>
|
|
You could put =CHAR(10) in a helper cell (A1 used here), and use
this.........
=H2&A1&I2&A1&J2&A1&K2
or
=CONCATENATE(H2,A1,I2,A1,J2,A1,K2)
Vaya con Dios,
Chuck, CABGx3
<eyeman6513_2000[ at ]yahoo.com> wrote in message
news:1155394923.841114.322770[ at ]m79g2000cwm.googlegroups.com...
[Quoted Text] > 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?
>
|
|
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, eyeman6513_2000[ at ]yahoo.com wrote:
[Quoted Text] >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?
|
|
This is working, thank you.
Gord Dibben wrote:
[Quoted Text] > 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, eyeman6513_2000[ at ]yahoo.com 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?
|
|
|