How to concanate 2 col in single col?

[VBABEGINER]

I have data in Col AG 13 and AI 13.
I want to concatenate this data in COL O.
Experts, How do i do this?
This is in the case of two column.
How can concanate done for 3 or 4 columns?
Masters help required?

 

[VoG]

Try

=AG13&AI13

 

[VBABEGINER]

Sir,
can i get by coding?

 

[VoG]

Maybe like this

Sub concat()
Dim LR As Long, i As Long
LR = Range("AG" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    Range("O" & i).Value = Range("AG" & i).Value & Range("AI" & i).Value
Next i
End Sub

 

[VBABEGINER]

I wanted to say something about MrExcel.
I didn’t understand your brain. God has manufactured special kind brain items, that is You guys “MrExcel”.
You guys are really Awsome….and your knowledge is Excellent!!
Cheers!!


ray:

 

[VBABEGINER]

one query still left guys.

how can be done concatenate for 3 col or 4 col?

 

[VoG]

Just add in more ranges

Sub concat()
Dim LR As Long, i As Long
LR = Range("AG" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    Range("O" & i).Value = Range("AG" & i).Value & Range("AI" & i).Value & Range("BA" & i).Value
Next i
End Sub

 

[VBABEGINER]

Thank You Sir.