I had a bit of a tough time knowing exactly what you want from the info you
gave. (As in what do you want to put in A1 if B1 is not text.)

Give this a try in anycase and see if it is what you want. Put this formula
in A1 and then copy it down for as many rows of B as you have. IF the B cell
is test it will display that text in A, if not it just sticks a blank in A.

=IF(ISTEXT(B1),B1,"")

"CLibby" wrote:

Trying to figure out an equation -- I need cell A1 to fill-in by data from
column B, if B1 has text fill in A1, if B1 doesnt have text, move to cell B2,
etc. etc,,,,but if B1 has text and fills in A1, need A2 to replicate A1
procedure starting with B2, etc,etc. If someone can help me out or let me
know if it is even possible I would appreciate it.