|
|
#1
03-03-2020, 09:41 AM
|
|||
|
|||
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? 
|
|
|
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 |
Windows XP 
Office 2016
Threaded Mode