I have a list of names. The names have blanks in between them.

I want to put these names into a list with no gaps.

Any Idea's?

The list needs to be one cell after the other

--
Message posted from http://www.ExcelForum.com