View Single Post
 
Old 03-03-2020, 10:39 AM
Charles Kenyon Charles Kenyon is online now Windows 10 Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 7,659
Charles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud ofCharles Kenyon has much to be proud of
Default

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.
Reply With Quote