---

Hejsa.

Jeg har en tabel med 4 rækker.


Hvordan laver man, så værdien af row1 og row2 bliver 'smeltet sammen' og lagt i row3 - altså hvis row1 er blue og row2 er fish - så skal værdien af row3 bliver bluefish.

Nogle ideer, jeg er efterhånden blank.

---

Går ud fra at det er i excel...

Merge the contents of multiple cells into one cell

You can use a formula with the ampersand (&) operator to combine text from multiple cells into one cell.

1. Select the cell in which you want to combine the contents of other cells.
2. To start the formula, type =(
3. Select the first cell that contains the text that you want to combine, type &" "& (with a space between the quotation marks), and then select the next cell that contains the text that you want to combine.

To combine the contents of more than two cells, continue selecting cells, making sure to type &" "& between selections. If you don't want to add a space between combined text, type & instead of &" "&. To insert a comma, type &", "& (with a comma followed by a space between the quotation marks).
4. To finalize the formula, type )
5. To see the results of the formula, press ENTER.

---

I celle a3 skriver du:

= a1 & a2

Mvh W.

---

Forlængelse af kalleanker's forklaring.

Blue: A1
Fish: B1
Formel =(A1&" "&B1)

Husk mellemrum mellem de 2 " (altså " ")

Håber du får løst dit problem

Dette spørgsmål er blevet annulleret, det er derfor ikke muligt for at tilføje flere kommentarer.