IF AND forumla is giving me a circular ref error

Hi guys,

I'm using an excel forumla to scan column A of a sheet and bring a number over from it if it has the word "DOC" in front of it. The column that I want these to appear in sometimes has a number in it already so I want excel to use this formula
=IF(LEFT(A2,3)="DOC",MID(A3,6,12),"")
but only when the cell in column B it's pasting into is blank. So i'm trying to include AND(B2<>"") somewhere in there so it does nothing if there's something there already.

Can anyone help with this?

Cheers,
Manolis

Manolis, do you mean?

=IF(B2="","",IF(LEFT(A2,3)="DOC",MID(A3,6,12),"")

Manoli, kita afto(Look at this)

=IF(B1="","",IF(LEFT(A1,3)="DOC",MID(A1,7,12)))

That still doesn't seem to work for me Fotis,

I either get a circular ref warning or it brings everything up as a zero.

See this, my friend.

What do you say about?

Kalimera Manolis.

I am sorry but i don't think that you can do this using formula.

In a cell you can have either a formula or a nalue(or text). Not both of these.

Maybe with VBA, but in this case i am not able to help you.