New_Here
04-20-2017, 12:44 AM
Hi Guys Good Evening from Sri Lanka,
I need a UDF or a formula for the below Argument.
Cell A1 = Mobile Contact Number
Cell A2 = Mobile Contact Number
Cell A3 = Mobile Contact Number
Cell A4 =(,) << A coma is mentioned here.
I get to fill lots and lots of Customer Information for a day.
Case 1 - If No Customer Number is available I will just Type "N/A" on Cell A1, then Outcome should be in B1 = N/A
Case 2 - If 1 Customer Number is available I will just Type the No. on Cell A1, then Outcome should be in B1 = The Number in A1
Case 3 - If 2 Customer Numbers are available I will just Type the No.'s on Cell A1 & A2, then Outcome should be in B1 = A1<Space><coma>A2
Case 4 - If 3 Customer Numbers are available I will just Type the No.'s on Cell A1, A2 & A3 then Outcome should be in B1 = A1<Space><coma>A2<Space><coma>A3
Is this Possible or am I asking for too much? :(
Please help.
Thank You.
I need a UDF or a formula for the below Argument.
Cell A1 = Mobile Contact Number
Cell A2 = Mobile Contact Number
Cell A3 = Mobile Contact Number
Cell A4 =(,) << A coma is mentioned here.
I get to fill lots and lots of Customer Information for a day.
Case 1 - If No Customer Number is available I will just Type "N/A" on Cell A1, then Outcome should be in B1 = N/A
Case 2 - If 1 Customer Number is available I will just Type the No. on Cell A1, then Outcome should be in B1 = The Number in A1
Case 3 - If 2 Customer Numbers are available I will just Type the No.'s on Cell A1 & A2, then Outcome should be in B1 = A1<Space><coma>A2
Case 4 - If 3 Customer Numbers are available I will just Type the No.'s on Cell A1, A2 & A3 then Outcome should be in B1 = A1<Space><coma>A2<Space><coma>A3
Is this Possible or am I asking for too much? :(
Please help.
Thank You.