Try this formula from Chip Pearson's website.

http://www.cpearson.com/excel/noblanks.htm

I don't think you need VBA.

Cheers,

Gromit



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/