Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Carriage Return in a Concatenation
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Carriage Return in a Concatenation
=H2&CHAR(10)&I2&CHAR(10)&J2&CHAR(10)&K2
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... 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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Carriage Return in a Concatenation
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 wrote in message oups.com... 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? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Carriage Return in a Concatenation
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? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
symbol to represent a carriage return | Excel Worksheet Functions | |||
Excel import txt file carriage return as delimiters | Excel Discussion (Misc queries) | |||
Text to columns delimited by carriage return | Excel Worksheet Functions | |||
how do I make hard carriage return appear in pivot table? | Excel Discussion (Misc queries) | |||
Carriage Return in Excel | Excel Discussion (Misc queries) |