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.
thx,
Bobby Hesley.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
find /
replace blank
and so on for everything.
Select the column in which numbers are present.
ASKER
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.