Text Help Please!!!!

[amyacc]

I have an excel sheet with different address lines in multiple cells (ie: name in B1, Address first line B2, Address second line B3, etc). I need a way to combine these into one cell AND be able to have it look like an address, one line on top of the next, etc.

Please let me know if this is possible. ASAP please!

THANK YOU!!!!!!!

 

[Greg Truby]

Es bastante fácil. Use la fórmula siguiente: <ul>[*]=B1&CHAR(10)&B2&CHAR(10)&B3[/list] Favor sepa que hay que asegurarse que el atributo para Wrap Text esté encendido para la celda con la fórmula.