das Verketten kannst du dir sparen, so gehts k?rzer: =(A1&B1)*1
Das Formatieren musst du ?ber VBA machen.
mfg Bert
Sub test()
For i = 1 To 20000
With Cells(i, 3)
If Cells(i, 2) = "" Then
.Value = Cells(i, 1).Value
.NumberFormat = " 00#"".""##"".""##"".""###"
Else
.Value = Cells(i, 1) & Cells(i, 2)
.NumberFormat = " 00#"".""##"".""##"".""###"".""##"
End If
End With
Next
End Sub
Sub test()
For i = 1 To 20000
With Cells(i, 3)
If Cells(i, 2) = "" Then
.Value = Cells(i, 1).Value
.NumberFormat = " 00#"".""##"".""##"".""###"
Else
.Value = Cells(i, 1) & Cells(i, 2)
.NumberFormat = " 00#"".""##"".""##"".""###"".""##"
End If
End With
Next
End Sub