excel advanced - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced - Excel,

excel advanced - Excel,

resolvedResolved · Low Priority · Version Standard

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

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Quickly hide and unhide rows and columns

Use the keyboard shortcut Ctrl+9 to hide selected rows and Ctrl+0 to hide selected columns. The good thing about this shortcut is that you do not need to select entire rows or columns. For example, select B3:D3 then press Ctrl+0 to hide columns B to D.

Ctrl+Shift+9 unhides rows and Ctrl+Shift+0 unhides columns.

View all Excel hints and tips


Server loaded in 0.09 secs.