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
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
Click (*) if you received helpful response.
Regards,
David
And when I delete A2 it is staying A1.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks