Try this on a spare copy

Select col B
Press F5 Special Blanks OK
Right-click Delete Entire row OK
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"DavidObeid" wrote
in message ...

I have a spreadsheet with 2 columns (that are each the result of
different formulas). Both columns contain some blank cells. Column A
contains numbers (12, 11, 10 .. 7), column B contains names.

I need to somehow get Excel to reproduce the lists without blank spaces
in the 2nd column.

For example:

A B
12 John Smith
Fred Bloggs

Peter Piper
Porky Pig
11 Mickey Mouse
Clint Eastwood



Needs to become:

A B
12 John Smith
Fred Bloggs
Peter Piper
Porky Pig
11 Mickey Mouse
Clint Eastwood

Any help is greatly appreciated.

If the solution involves VBA please give me idiot proof steps as to how
to implement it.


--
DavidObeid


------------------------------------------------------------------------
DavidObeid's Profile:
http://www.excelforum.com/member.php...fo&userid=2238
View this thread: http://www.excelforum.com/showthread...hreadid=489661