We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel cell combination


shellship
Resolved

Likes # 0

I need to join the contents of two cells together. Cell one has the First Name and the next one the Surname. I need to end up with the First Name and the Surname in the the one cell in order to export the file of names into another application. Merging two cells only keeps the first bit of data.

Vog where are you please? Should be able to automate with a macro but don't see how to do it.

Like this post
shellship

Likes # 0

Just found it on the web. For those interested, =a1&" "&b1.

Vog can go back to sleep.

Like this post  

Reply to this topic

This thread has been locked.



IDG UK Sites

iPad mini 3 vs iPad mini 2 comparison: New iPad mini 3 isn't worth £80 more

IDG UK Sites

Why you shouldn't buy the iPad mini 3: No wonder Apple gave it 10 seconds of stage time

IDG UK Sites

Halloween Photoshop tutorials: 13 masterclasses for horrifying art, designs and type

IDG UK Sites

Should I upgrade from Mavericks to OS X 10.10 Yosemite? What you need to know before updating to...