Save your work and then try:

Select column A. Hit F5. Click on Special. Click on Blanks, then OK.
Type = and then hit Up Arrow. Hold Control Key and hit Enter.

Hope this helps
Rowan

bleu808 wrote:
All,

I am sorry to start this as a new thread - but I think some may see the
original as closed, and not look at any new posts. Just looking for
some help
------------------------
Can anyone help with a variation if this earlier thread? This is
exactly what I am looking for, except I am not using a date function -
I am using text.

so, I have few cells that look like this. (actually have about 8,000
cells worth of info on the spreadsheet.)


A
1 BOB
2
3
4
5 MIKE
6

So, what I am trying to is this - just what I thought might work...

a2 is blank, it should = a1 - thats easy... but - a5 is not blank - i
want it to remain as Mike. I used this variation, since I am not using
time.

=IF(a5=" ",a4,NOP)

Thanks all!

Bleu