Jeroenzelf92
New member
- Joined
- May 4, 2015
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Dear members,
I have a question about Excel 2013. I spend like a hour to get it done, but it seems like the whole internet is able to do it except for me.
I have a Excel file where I want to combine two cells which contains a first name and a surname into one cell. Simple as that. Now, the internet states that I have to type in the next formula (in case the first name is in cell A1 en Surname in cell A2):
=(A1&" "&A2)
Great story, but when I press enter I see this code as text in the cell I typed it in, and not the combined First- and Surname. Am I doing something wrong? Would be great if someone could help me out!
Thanks!
I have a question about Excel 2013. I spend like a hour to get it done, but it seems like the whole internet is able to do it except for me.
I have a Excel file where I want to combine two cells which contains a first name and a surname into one cell. Simple as that. Now, the internet states that I have to type in the next formula (in case the first name is in cell A1 en Surname in cell A2):
=(A1&" "&A2)
Great story, but when I press enter I see this code as text in the cell I typed it in, and not the combined First- and Surname. Am I doing something wrong? Would be great if someone could help me out!
Thanks!