ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with Enter

Wed
Dec 7
2011

How can I combine two cells into one with Enter between them?

I have cell A1 with name, B1 with Address, I want C1 to have NAme from A1 in one line, then the Address from B1 in line below, I don't want to go all over my 13000 cells to do that manually


Answer

That is very good question, here is what you need to do:
In C1, paste this:
= A1&CHAR( 10)&B1

You might need to select "Wrap Text" to show that

The CHAR(10) is what is called the Enter inside the cell.

Wednesday 12/7/2011 10:50:00 AM

Tags

History