Translations:Faq/Calc/032/5/en

    From The Document Foundation Wiki

    It is also possible to use this function:

    =CONCATENATE(B2;".";A2)