Link to home
Start Free TrialLog in
Avatar of bobhes
bobhes

asked on

Nothing but the numbers

i have an excel file with phone numbers in it that have variations of dashes and parentheses, spaces, periods, etc.. I need to be able to change all the phone numbers to be just the individual phone numbers crunched together with no dashes, periods, spaces, or parentheses. please advise on how to eliminate everything but the numberss

thx,
Bobby Hesley.
ASKER CERTIFIED SOLUTION
Avatar of zorvek (Kevin Jones)
zorvek (Kevin Jones)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bobhes
bobhes

ASKER

I appreciate your answer, but I don't understand any of this. I'm totally new to excel. I don't know macro order general function or anything like that. I just need to know how to eliminate dashes, etc.. Please give me some simple steps I can understand

thx,
Bobby

Here's my original question:
 i have an excel file with phone numbers in it that have variations of dashes and parentheses, spaces, periods, etc.. I need to be able to change all the phone numbers to be just the individual phone numbers crunched together with no dashes, periods, spaces, or parentheses. please advise on how to eliminate everything but the numberss

thx,
Bobby Hesley.

If you not willing to follow the directions above to add and use a macro, you are going to have to use the find and replace function for each of the characters you want to remove...

Select the cells to edit. Press CTRL+H and enter the character to remove in the first text entry box. Clear the second text entry box. Click Replace All. Repeat for each character you want to remove.

Kevin
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please mention whether you want to do it manually or programatically. In case to do programatically the above answers will help you else you can use replace from the edit menu.

find /
replace blank
and so on for everything.

Select the column in which numbers are present.