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.
Thank you in advance,