removing a space in a phone number

Have you tried Find and Replace (using a space and the null characters)?

Yes it deletes the phone number altogether.

Hi,

In that case you're using Find and Replace incorrectly. Describe EXACTLY what you do, step by step so that we can tell you where you are going wrong.

Don't use * *, use " " and, in the options, make sure you haven't selected match entire cell contents.

Edit: * is a wild card. What you are saying is find a space with anything before and after and replace it all.


Regards, TMS

dont put " " just in find use the space bar

@martin: thanks, difficult to describe putting a space in ...


@rob:

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save