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

If your entries don't have any embedded spaces, you could use a formula like:

=SUBSTITUTE(TRIM(A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1)," ",", ")


ldiaz wrote:

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

--

Dave Peterson

Hi Dave
this Formul work very good,
Thank you so much for your help

Ld
--
Lorenzo DÃ*az
Cad Technician


"Dave Peterson" wrote:

If your entries don't have any embedded spaces, you could use a formula like:

=SUBSTITUTE(TRIM(A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1)," ",", ")


ldiaz wrote:

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

--

Dave Peterson