Hi Experts,

I need you help. I have the below formula in cells G3:G2500. What I would like is a way to have that formula auto populate in range G:G as a user enters data in cell a. For example, the formula would appear in Cell G:3 as a user starts to enter data in cell A:3.

Here is the formula:
=IF(AND(A3<>"",B3<>"",H3<>""),IF(AND(I3="",K3=""),CONCATENATE("FS.",H3,".",A3,".",LEFT(B3,2),".",MID(B3,3,4)),IF(AND(I3<>"",K3=""),CONCATENATE("FS.",H3,".",A3,".",LEFT(B3,2),".",MID(B3,3,4),".",I3),IF(AND(K3="YES",H3="RA"),CONCATENATE("FS.RA.",A3,".",LEFT(B3,2),".",MID(B3,3,4),IF(I3<>"",CONCATENATE(".",I3),"")),IF(AND(K3="NO",H3="RA"),CONCATENATE("FS.RX.",A3,".",LEFT(B3,2),".",MID(B3,3,4),IF(I3<>"",CONCATENATE(".",I3),"")))))),"")

Any ideas?

Thanks,

JP