Remove comma (,) from the end of a cell

[niladri20052006]

Hi All I want to remove comma (,) from the end of a cell but not from the middle. I have a huge list consisting of Address 1 and address2. First I have tried CONCATENATE to add these two cells. But there are some columns blank in address 2

Address 1 Address2 Result
1258 Park Place Suite 200 1258 Park Place,Suite 200
1775 Logan Ave Blank 1775 Logan Ave

But when I am doing this I am getting the result 1258 Park Place,Suite 200 and 1775 Logan Ave,. I do not want comma in the second column.

Is there any way to do that quite easily.

Thanks in advance!

 

[Andrew Poulsom]

Like this?

=A2&IF(LEN(B2),","&B2,"")

 

[niladri20052006]

Thanks a lot Andrew!

Formula is working fine