Sorry, but you have to correctly create concatenation formula!
Look again on my original post: https://archive.sap.com/discussions/thread/3673612
=IF(B2<>"";MID(B2;24;LEN(B2)-24)&IF(D3<>"";","&D3;"")
D3 not B2!!!!
P.S. And please correct the question tag - has to be
P.P.S. Corrected formula:
=IF(B2<>"";MID(B2;24;LEN(B2)-24);"")&IF(D3<>"";","&D3;"")
Hi Vadim,
Thanks for the response and i did the same what you mentioned ,but the again am getting the formula error.
Am really confused it is working in your system but the same logic not working in my system. I don't no what mistake i did .
Can you help me on this.
=IF(B2<>"";MID(B2;24;LEN(B2)-24);"")&IF(D3<>"";","&D3;"")
Best Regards,
Gowtham.
Add comment