goto special blanks does not return any blank cells

[Guest]

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

 

[Max]

Try Debra Dalgleish's nice coverage on this at her:
http://www.contextures.com/xlDataEntry02.html
where she lists 2 methods to do so
(one manual, the other programmatically*)
*Sub FillColBlanks by Dave Peterson

 

[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

 

[Gord Dibben]

Max

See OP's subject line.

Gord

 

[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 ..

 

[Gord Dibben]

Max

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

We may never know<g>

Hope OP posts back.

Gord

 

[Max]

My thoughts at first but.....??
We may never know<g>
Hope OP posts back

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

 

[Debra Dalgleish]

And one more guess, in this post by Dave Peterson:

http://groups.google.com/groups?&[email protected]

 

[Guest]

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

 

[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