Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but the
number.

Without a macro you can use Find and replace. Enter the character you want
to delete in the Find field and leave the Replace field blank.



"DEI" wrote:

Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but the
number.

On Apr 29, 3:14*pm, "DEI" wrote:
Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? *I have some phone numbers I need to remove everything but the
number.

You can do it by selecting the column that contains the phone numbers,
or at least all the cells that contain phone numbers, then use the
Replace function from the edit menu. Type a space in the find field,
and leave the replace field blank; click Replace All. You can do this
with the other characters as well - put them in the find field and
leave the replace field blank (not even a space). If it prompts you to
search the rest of the worksheet, click NO, otherwise it will remove
spaces or parenthesis from all of your data.




Steven

hey! I used find/replace and got rid of the parenthesis. Now I just need
to remove the space from 123 4567

"DEI" wrote in message
...
Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but
the number.

Hi
No macro needed, use Find/Replace.

Select target range.

Goto Edit Find Check Replace In the Find Field enter left or right
paranthes or space in Replace Field enter nothing Replace all.

Regards,
Per

"DEI" skrev i meddelelsen
...
Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but
the number.

Same procedure.

DEI wrote:

hey! I used find/replace and got rid of the parenthesis. Now I just need
to remove the space from 123 4567

"DEI" wrote in message
...

Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but
the number.

Just hit SPACE bar in find

"DEI" wrote:

hey! I used find/replace and got rid of the parenthesis. Now I just need
to remove the space from 123 4567

"DEI" wrote in message
...
Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but
the number.

worked like a champ guys! Thanks a million!

"Per Jessen" wrote in message
...
Hi
No macro needed, use Find/Replace.

Select target range.

Goto Edit Find Check Replace In the Find Field enter left or right
paranthes or space in Replace Field enter nothing Replace all.

Regards,
Per

"DEI" skrev i meddelelsen
...
Anyone have a macro that will remove spaces (no matter where) and remove
parenthesis? I have some phone numbers I need to remove everything but
the number.