removing characters

[DEI]

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.

 

[Sandy]

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.

 

[sbitaxi]

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

 

[DEI]

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

 

[Per Jessen]

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

 

[Bob I]

Same procedure.

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

 

[Sandy]

Just hit SPACE bar in find

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

 

[DEI]

worked like a champ guys! Thanks a million!

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