Re: Merging cells

"kolds" <kolds@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6C22AB19-C1E8-470F-BEB7-6CCB47BBD905@xxxxxxxxxxxxxxxx
We have many excel spreadsheets that we use to track employees. My
company
just recently transfered the info from Word to Excel. I am new to the
company and fairly new to Excel. We have decided to merge the name cells
from two to one (one cell-first name, one cell-last name). We want to do
this to help in our searches for people. I have no idea how to do this.
I
am sure there has to be an easier way than retyping everyone name into one
cell. Any advice would be appreciated!

Firstly merging cells is a bad idea. One simple example. Having merged
cells to form one, say John Smith, how would you do a sort on surname? The
same comment goes for addresses where it is better to have separate fields
for <House number>, <Street name>, <Locality>, Town>, <County>, <Postcode>.
Indeed you would want separate data if you want to do a mail merge. It is
far easier concatenate (join) information than it is to separate afterwards.
Have a look at my information *** at
www.1001solutions.co.uk/designing_a_spread***.pdf

Oh! to answer your question (if you really must)
=A1&" "&B1

Regards.

Bill Ridgeway
Computer Solutions


.