Merge 2 columns into one

[Hussein982]

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]

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]