Hello all

I have these field
Cut Shortages Assy Shortages
R3 V3
in field AF3 I have this formul,
=IF(R3<"",R3,"")&IF(V3<"",V3,"")

but when I fill R3 with a shortage like VEA-00200 and V3 with another
shortage like MSO1020
AF3 show Both shortages so: VEA-00200MSO1020
I would like to have them like VEA-00200, MSO1020
that is the first problem, I resolved using this formul
=IF(R3<"",R3,"")&IF(V3<"",", ","")&IF(V3<"",V3,"")
but now the problem is when R3 does not have information, and V3 do have,
the AF3 show the shortage so: , MSO1020 I would like to have it like :MSO1020
but when R3 do have also information AF3 must show result as : VEA-00200,
MSO1020

anybody can help me, I will appreciate so much.

--
Lorenzo DÃ*az
Cad Technician