#1
|
|||
|
|||
Convert text to phone number in merge
I am importing data from excel for phone numbers that is is formatted as follows: +1 2345678910. I cannot figure out how to use a swith to format to (234) 567-8910? Can you help?
|
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reliable way to convert text to number with a formula | levraininjaneer | Excel | 8 | 12-22-2019 04:47 PM |
Attendance table Text Value Convert to Number | NickFazer | Excel | 2 | 11-08-2018 01:29 AM |
Cannot Convert Text Cell to number format to be able to sort the data | jyfuller | Excel | 10 | 06-19-2013 05:31 PM |
Extracting a phone number from a string that contains text and numbers. | hommi16 | Excel | 2 | 06-05-2013 09:19 PM |
Convert Number to Text | devcon | Word | 0 | 07-10-2010 01:16 AM |