A simple way to achieve this is to use the List calculation function in your calculation. Try this:
Substitute ( List ( YourDatabase::NameFirst ; YourDatabase::NameLast ) ; "¶" ; " " ) & "¶" &
YourDatabase::AddCity & " " & YourDatabase::AddProvince_State ;
Let me know if this does the trick for you.
Actually, I just discovered the list function earlier today, when I was trying to solve a relationship problem, but I can now see -- byt the example you provide -- hyow the list function can be used in another way. Great!