The code at that link does not use a formula in the output cell... it is putting constants into the cell... and, as Fluff said, you can do it with VBA (like the link did), but you cannot have a formula in that cell (only constants like at your link). You would have to provide full details about what is being concatenated and exactly what that concatenation should look like, but it should be possible to create some event code that would act like a formula (concatenation that responds to changes in the cells that are being concatenated just like a formula would do). Let the forum know if you want to pursue this approach.
Thanks for your reply. I have this working minus the event code you're describing. Here's what I have so far. Could you help me so it updates dynamically? Thanks again!
Private Sub Worksheet_Change(ByVal Target As Range)
Dim i As Long
Dim First As Variant
Dim Second As Variant
Dim Both As Variant
Set First = Range("A200")
Set Second = Range("B200")
Set Both = Range("B21")
Application.EnableEvents = False
Both.Value = First.Value & " " & Second.Value
done = 0
For i = 1 To Len(Range("B21").Value)
If done = 0 Then
Both.Characters(i, 1).Font.Color = vbRed
Both.Characters(i, 1).Font.Name = "Calibri"
End If
If done = 1 Then
Both.Characters(i, 1).Font.Color = vbBlack
Both.Characters(i, 1).Font.Name = "Times New Roman"
End If
If Mid$(Both.Value, i, 1) = " " Then
done = 1
End If
Next
Application.EnableEvents = True
End Sub
