LinkBack URL
About LinkBacks
Hello, I need to concatenate strings from column with each strings from other column
What is the correct code for macros?
A B
st1 ar1
st2 ar2
st3 ar3
result
st1ar1
st1ar2
st1ar3
st2ar1
st2ar2
st2ar3
st3ar1
st3ar2
st3ar3
Hello, I need to concatenate strings from column with each strings from other column
What is the correct code for macros?
A B
st1 ar1
st2 ar2
st3 ar3
result
st1ar1
st1ar2
st1ar3
st2ar1
st2ar2
st2ar3
st3ar1
st3ar2
st3ar3
Sub Macro1() LR = Cells(Rows.Count, 1).End(xlUp).Row Columns("A:A").Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove Range("A1:A" & LR).FormulaR1C1 = "=RC[1]&RC[2]" Range("A1:A" & LR).Value = Range("A1:A" & LR).Value Columns("B:D").Delete End Sub
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks