excel advanced

excel advanced - Excel,

Resolved · Low Priority · Version Standard

Excel,

Dianne has attended:
Excel Intermediate course

by - delegate Dianne [5 posts] (2007 Oct 5 Fri, 12:00) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	5	book now	£450	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Excel,

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 5 Fri, 13:05) Reply

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,

by - delegate Dianne [5 posts] (2007 Oct 5 Fri, 13:08) Reply

No, as they are telephone numbers the amounts of digits will be different.

Thanks
Dianne

RE: Excel,

by - trainer Amanda diamond contributer [1240 posts] (2007 Oct 5 Fri, 13:51) Reply

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