Consolidating Rows
 

I'm using Excel 2007. I have a huge spreadsheet that I need a little help
consolidating. Each row has a series of columns (K-BK) that has either a dash
(-) or a name in it. I'd like to remove all the dashes and "slide" the
name(s) over so that they start in BL.

Here's a smaller example:

columns:
A B C D E
- Jim - - -
- - - - Jon
- - Jim - Jon

What I'd like to see in colum F & G is:
Jim
Jon
Jim Jon

Is there a way to do that? I can easily change the dash to something else if
need be.

Thank you for any suggestions/help!!
Cathy