Merge 2 columns into one

Question

Hi All: Whats the fastest way to to merge two columns into one

For example: I have a column in excel is first name (Alain) and second column is (smith). I would like to merge these two column into one.

I appreciate if you could add a workflow in your reply.

Cheers,

Deano478 · Answer

Hey @Hussein982 you can use a formula tool to do this.:

1. Add a column using the formula or update and existing column

2. The formula would be like so: [firstname] + ' ' + [secondname]