IT:AD:excel:HowTo:Combine Two Cells Into One
Summary
Sometimes you want to combine two cells – maybe hidden cells – into one one:
| ID | Name | Description | Name and Description |
|---|---|---|---|
| 123 | Foo | About foo… | Foo About foo… |
Process
You can use a formula such as:
=CONCATENATE([@NAME],CHAR(10),[@DESC])
Note that without VBA you can't bold a part of a cell 