| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing Hyphens in phone list???
I have a list with phone numbers displayed with hyphens. I need to remove
these hyphens "###-###-####" in order to export to Access table. How do I do this in Excel????. Thank you in advance for any help you can provide. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Hyphens in phone list???
the simpliest way is to use in the Edit Menu - Replace. Highlight the column
with the phone numbers then replace the hyphen with nothinig. the replace line should be blank. "TotallyConfused" wrote: I have a list with phone numbers displayed with hyphens. I need to remove these hyphens "###-###-####" in order to export to Access table. How do I do this in Excel????. Thank you in advance for any help you can provide. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Hyphens in phone list???
Will this leave blank spaces instead of hyphens? I don't want blank spaces.
I want the number to read: "##########" Thank you "Joel" wrote: the simpliest way is to use in the Edit Menu - Replace. Highlight the column with the phone numbers then replace the hyphen with nothinig. the replace line should be blank. "TotallyConfused" wrote: I have a list with phone numbers displayed with hyphens. I need to remove these hyphens "###-###-####" in order to export to Access table. How do I do this in Excel????. Thank you in advance for any help you can provide. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Hyphens in phone list???
If you want a blank space then put a blank space in the replace box, it you
want nothing then put nothing in the replace box. "TotallyConfused" wrote: Will this leave blank spaces instead of hyphens? I don't want blank spaces. I want the number to read: "##########" Thank you "Joel" wrote: the simpliest way is to use in the Edit Menu - Replace. Highlight the column with the phone numbers then replace the hyphen with nothinig. the replace line should be blank. "TotallyConfused" wrote: I have a list with phone numbers displayed with hyphens. I need to remove these hyphens "###-###-####" in order to export to Access table. How do I do this in Excel????. Thank you in advance for any help you can provide. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing Hyphens in phone list???
Replace does work and it does not leave a blank space. Thank you very much
for all your help. Have a great day! "Joel" wrote: the simpliest way is to use in the Edit Menu - Replace. Highlight the column with the phone numbers then replace the hyphen with nothinig. the replace line should be blank. "TotallyConfused" wrote: I have a list with phone numbers displayed with hyphens. I need to remove these hyphens "###-###-####" in order to export to Access table. How do I do this in Excel????. Thank you in advance for any help you can provide. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove hyphens from a list of part numbers | Excel Worksheet Functions | |||
| Macro For Removing Hyphens | Excel Discussion (Misc queries) | |||
| Automatically removing hyphens from ID# or SSN. | Excel Discussion (Misc queries) | |||
| removing dashes from phone numbers | Excel Discussion (Misc queries) | |||
| Does XL2K have "hard hyphens" (non-break hyphens)? | Excel Discussion (Misc queries) | |||
Linear Mode
