You would use a "picture switch."
Field Switches and Pictures

That will handle the phone number but not the +1. If possible use a helper column in your Excel to strip that out and use that helper column as your data source.