Blank Cells that Aren't Blank? I'm baffled....

[FiservEFTSalesOps]

Here's one that has me baffled.

I've been given a worksheet with data laid out like that in a pivot table. (It's an extract from an SAP database) I want to fill-down the blank cells so a pivot table or filtering can be run against it.

Here's the problem.... the cells below the column labels that appear to be blank aren't. When I use the "Cell Type" function they are identified as "I" for label.

Specifically, columns A & B have the data that needs to be filled-down until the next non-blank. I know how to do this if the cells below the labels were blank. However, since the "blank" cells aren't truely blank, I'm stuck. Help anyone??

 

[brettdj]

You may have the Character 160 problem

background
http://office.microsoft.com/en-us/e...-beginning-and-end-of-a-cell-HP003056131.aspx

Chip Pearson has a symboliser addin tool here
http://www.cpearson.com/excel/chars.htm

Cheers

Dave