Unused portions in a calculation
Is there a way to not have unused parts of a calculation appear.
I am creating a phone book. I have a table with fields for each element of a phone number (country code, area code, number, and extention). I have a calculation that put all the elements together. Before the field extention I have an "x" to indicated what the field is. If I create a record that doesn't have data in the extention field, the "x" still appears. Is there any way to prevent that?