Merging Columns

A

Amazincomes

Hello All,

New to this malarky so I apologise in advance if this is a stupid question :)

I have an Excel worksheet that contains long columns of names, one with first
names, the other with surnames. Is it possible to merge the two columns so the
date from both appears in just one column?

Thanks in advance...


Seamus Houghton

"One dream, one soul, one prize, one goal, one golden glance of what should
be..." www.ownyours.co.uk
 
K

Ken Wright

Assuming your data in Cols A & B starting row 1, then in cell C1 put

=A1&" "&B1 for merge with a space
=A1&", "&B1 for merge with a comma and space
=A1&" - "&B1 for merge with a space and hyphen and space

then just copy the cell, select C2:Cxx and paste
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging from an Excel file with graphics 1
Need a proper guru! My head hurts ;( 1
Page numbering with Merged Document and IF statements 1
Help! Need to compare 2 sets of data 1
Complicated If Function Question 2
Macro to calculate, merge, and delete 10
Import data from excel 1
Function in Excel to count and list number of entries of text valuesin a row. 2

Top