Text in two columns into one

[Orla]

I have two columns - one with first name and the other with last
name.Which function do I use to create a new column where I have both
the first and last name together ? Can I also have just the last name
is capital letters ? Many thanks!

 

[masim]

look out for help on "concatenate"

or simply use

=a1 & " " &b1


Regards
Asim