Can we assume that in:
What I need to do is fill the blanks in column A when there is a value
to return
you meant B not A? If so:
0) if column C is already used, insert a new column C
1) copy B1 to C1 (I will assume the first BBBBBB is in B1. If not just
adjust the references to fit your situation)
2) In C2 enter =IF(ISBLANK(B2),C1,B2)
3) Copy this formula down the column by dragging the fill handle (small
solid square in lower right corner of active cell)
4) Select all of the C entries and use Copy; now with C still selected use
Edit | Paste Special and specify Values. Your formulas are now changed to
actual values
5) Delete the column B since column C now has what is needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ps.com...
Hi All,

I have the following data.

Column A Column B
AAAAA BBBBBB
AAAAA
AAAAA
AAAAA
AAAAA CCCCCCCC
AAAAA
AAAAA
AAAAA

What i need to do is fill the blanks in column A when there is a value
to return.

i.e. every line cell in column B needs a value from above??

does that makes sense? i have been looking at this for 4 hours now and
don't konw myself what day it is!!! :(

thanks again.

Craig