| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I take out a dash in a number like 827-6541 in a XL list
I have a "list of fax #s in xl that I am tyring to send as a broadcast fax.
The service I have requires that the fax number be in a format with no characters other than the numbers. For example, (912) 678-8344 must be changed to 19126788344. Not characters other than numbers and no spaces. Can anyone tell me a way to do this without reinventing the computer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I count the number of repeats in a list of data? | Excel Discussion (Misc queries) | |||
| Select every 10th number in a list | Excel Discussion (Misc queries) | |||
| Lookup in a list of number with a headline | Excel Discussion (Misc queries) | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
Threaded Mode
