If concatenate

[Anto_BT]

Here I have one excel file and i want to have formula in "G" to write like is writed manualy.
If posible with new row after wach one

I want to have like this in G

Befristet von: 20.06.2014
Befristet bis: 20.05.2014
Store oder Abt. Neu: Test for Store
Kostenstelle neu: Test for Kostenstelle
% Pensium: Test for % Pensium
MA im Std.-Lohn: Choice #2

Formula.xlsx

Thank you very much!

[Richard Buttrey]

Hi

Do you mean that you want the formula to generate the string you show in G2 or do you mean that you want G2:G7 to each show one of the 7 items you show in your post?

[Anto_BT]

I want in G2 forumula to show like in post.
But when is empty A2 or B2..... to don't show that.

Thank you

[SDCh]

like this:

=$A$1&": "& IF(A2="","", TEXT(A2,"dd.mm.yyyy"))&" "&$B$1&": "& IF(B2="","",TEXT(B2,"dd.mm.yyyy"))&" "&$C$1&": "&C2&" "&$D$1&": "&D2&" "&$E$1&": "&E2&" "&$F$1&": "&F2

[Anto_BT]

And when I delete A2 it is staying A1.

[Sam Capricci]

you could try this… =IF(OR(A2="",B2=""),"",$A$1&": "&A2&" "&$B$1&": "&B2&" "&$C$1&": "&C2&" "&$D$1&": "&D2&" "&$E$1&": "&E2&" "&$F$1&": "&F2)

[Anto_BT]

Yes, thak you but how can i put just in other line

A one line
B other line
C
D
E
F

Thank you

[Richard Buttrey]

Yes, thak you but how can i put just in other line

A one line
B other line
C
D
E
F

Thank you

In response to post #2 I guess others have take you at your word and that only G2 was relevant. If indeed you want entries in G2:G8 then can I suggest you upload a workbook which clearly shows what you want with various permutations.