Multiple cell texts into one

[Sorrowsong]

Greetings,

here's the request i have.There are 5 cells containing text like

Cell1: ABC
Cell2: DEF
Cell3: G12
Cell4: 345
Cell5: 678

What i want the new cell to show is : ABC.DEF.G12 and so on separating text from each cell with a dot (.)
Thanks in advance.

[Steve0492]

Try this:

=Cell1&"."&Cell2&"."&Cell3&"."&Cell4&"."&Cell5

Let me know if that works for you.

Steve

[jeffreybrown]

Here is a UDF you can try...

On the worksheet use >> =Concat()

Function Concat()
    Dim RowCtr As Double
    Dim TempStr As String
    TempStr = ""
    'Change the 1 below to 5 for all your rows
    For RowCtr = 1 To 5
        TempStr = TempStr & Cells(RowCtr, "A") & "."
    Next RowCtr
    
    Concat = TempStr
End Function

[HSV]

Oneliner:

Sub hsv()
  Range("F1") = Join(Application.Transpose(Range("A1").Resize(5).Value), ".")
End Sub

[Heartbreak_one]

Hi, how bout this

open up this pic,

Untitled1.jpg

then type in =CONCATENATE(A1;".";A2;".";A3;".";A4;".";A5)

hope this help