• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

Simple Merge Macro

EE Pros,

I'm trying to simply merge a First Name Column of data with a Last Name Column to give me a resulting FULL NAME Column.  In other words, I have John in Column B and Smith in Column C, same row.  I need a result in Column D of John Smith.  I tried recording a macro (with and without relative on) and to no avail.

Sample attached.

Thank you in advance,

1 Solution
Here is a simple macro

When building this macro you should select "Use Relative References".

Sub Macro1()
' Keyboard shurtcut: Ctrl+q
' B = First Name Column
' C = Last Name Column
' D = Full Name Column
' Put the cursor on column C and press Ctrl+q

    ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-2],"" "",RC[-1])"
    ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
Bright01Author Commented:
Perfect!  Thank you!

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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now