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.

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.

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.

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.

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.