Dianne has attended:
Excel Intermediate course
Excel,
We have a huge list of telephone numbers, is there an easy way in which we could delete all the gaps within these numbers other than one by one using F2. please please the list is HUGE
RE: Excel,
Hi Dianne
Thank you for your question. I understand how this could be a frustrating and time consuming process if you were to do it manually.
Can you please tell me if all the phone numbers have the same number of digits within them?
thanks
Amanda
RE: Excel,
No, as they are telephone numbers the amounts of digits will be different.
Thanks
Dianne
RE: Excel,
Hi Dianne
Using a simple find and replace should hopefully resolve this.
1. Go to Edit - Replace (or Ctrl + H)
2. Click the the Find what box, press the spacebar once (meaning find a gap of one space) - you don't need to type anything into the Replace with box.
3. Click Replace All. Excel will search for all instances of one space and replace it with no space, eliminating any spaces.
I hope this helps.
Amanda