Combining Name [SOLVED]

[keanur]

Good Day excel Ninja,


i want to ask you a question:


I have table which contain First name on Cell A1 and Last name on B1, now i want to combine this A1 & B1 as the result for C1. do you know what is the best and simple way to do it in excel.

thanks in advance.


warm regards,


Keanur

 

[Hui]

=A1&" "&B1

or

=Concatenate(A1," ",B1)

 

[keanur]

Hi Hui,


Thanks for grant it within few minutes.


have a nice day!

Keanur