Excel cell combination

  shellship 17:09 PM 05 Mar 12

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.

  shellship 17:16 PM 05 Mar 12

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

Vog can go back to sleep.


This thread is now locked and can not be replied to.

How to watch Rugby World Cup 2015 online: Watch live, catch up on-demand & stream the 2015 Rugby…

1995-2015: How technology has changed the world in 20 years

How to watch Adobe Max 2015: See Adobe unveil new Creative Cloud features for Photoshop,…

Live Photo tips: How to take Live Photos on the iPhone 6s, how to view, share, edit and find Live…