View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] eyeman6513_2000@yahoo.com is offline
external usenet poster
 
Posts: 15
Default 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?