goto special blanks does not return any blank cells

L

Lobo

I have a sheet that has a lot of blank cells in column A and data in colum
B. I want to automatically fill in theblanks in A with the information from
the cell above, so I can use the data in B in relation to A.

Excel 2002
 
G

Gord Dibben

Lobo

Did you select Column A first?

Perhaps the "blank" cells are the result of an IF statement in a formula?

Perhaps the "blank" cells contain a <space> or two?

Try =LEN(cellref) on one or two that look blank.

OR =ISBLANK(cellref)

Gord Dibben Excel MVP
 
M

Max

Yes, think I did <g>, but had "lightly disregarded" it,
after reading closer what was posted inside
(guessing the OP's "real" objective in the post ?)
hence the suggested response ..
 
G

Gord Dibben

Max

My thoughts at first but.....??

We may never know<g>

Hope OP posts back.

Gord
 
M

Max

Gord Dibben said:
My thoughts at first but.....??
We may never know<g>
Hope OP posts back
Click to expand...

And even if s/he doesn't,
think we've covered the bases between us, no? <bg>
 
L

Lobo

Gord,

Thanks for that info , I tried the =ISBLANK and it seems that the cells have
a space in them.

So How do I get rid of the "spaces" in all the cells?

I See that a few have replied and the discussion is interesting , I received
this spreadsheet so I do not know how it was created ( is the character a
space or is it a ??? character as per the YAhoo discussion)

Thanks to all
 
G

Gord Dibben

Lobo

There is a TRIM Function or CLEAN Function you could try on those cells with
spaces.

Alternatives..................

After this, you still may not get the results you want. In that case, there
could be HTML non-breaking space characters(160)in the data.

See David MCritchie's TRIMALL macro for further cleaning.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Gord Dibben Excel MVP
 
Top