excel consultant - Delete the cells which don't have any text in it

The UK's most regular instructor-led training courses.
Training information: excel consultant · Excel courses · Microsoft Excel Training
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Delete the cells which don't have any text in it

Xiaojing has attended:
Excel Advanced course

by - delegate Xiaojing [5 posts] (2007 Feb 19 Mon, 16:52) Reply

How to delete the cells in a body of datas if they don't have any text in it? Many thanks

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Delete the cells which don't have any text in it

by - trainer Garry gold contributer [188 posts] (2007 Feb 21 Wed, 09:52) Reply

Select the Cell then right click and click delete and this will delete the cell and move everything up

RE: Delete the cells which don't have any text in it

by - delegate Xiaojing [5 posts] (2007 Feb 21 Wed, 12:11) Reply

What I meant was when I got lots of data, it's painful if I delete each cell myself, is there a way I could delete the cells which have no text in it together?

RE: Delete the cells which don't have any text in it

by - trainer Garry gold contributer [188 posts] (2007 Mar 2 Fri, 09:18) Reply

There have you tried filtering and then deleting the blank cells

· Microsoft Office and the Small Business: Part 1 Excel
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Features and Functions for Accountants

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips