how to combine cells in excell

in a spreadsheet how do I combine B2 with ":" and C2 to get

contents of B2: contents of C2
Matt PinkstonAsked:
Who is Participating?
Kyle AbrahamsConnect With a Mentor Senior .Net DeveloperCommented:
Use the Concatenate function

= Concatenate(B2, ":", C2)

Note you can use a space ": " if you need the space between.
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
Alternatively, you can use the ampersand to concatenate:

ProfessorJimJamConnect With a Mentor Commented:
if you didn't bother with formula then here you use the below macro code to do it all at once

Sub joincells()
    Dim myrange, mycell As Range
    Set myrange = Sheets("sheet1").Range("B2", Range("B1047586").End(xlUp))
    For Each mycell In myrange
        mycell.Offset(0, 2) = mycell.Value & ":" & mycell.Offset(0, 1).Value
    Next mycell
End Sub

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.