View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default How do I merge column contents

No such thing as a stupdi question.

Insert a new column to the left of A: this will be column A, first name
is now column B, last name is now column C. In the first relevant cell
of column A (call it A1), enter this formula:
=B1&" "&C1
This merges the value of B1 and C1 with a space in between.

If you need to convert this to text, highlight all of column A, copy it
to the clipboard, then click Edit Paste Special, select Values, and
click OK.