Results 1 to 2 of 2

Thread: Merging columns

  1. #1
    waggamama
    Guest

    Merging columns

    Is there any way to merge a number of columns together without replacing the values? Trying to help a colleague with this one.
    Thanks
    Kylie Baxter

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Merging columns

    By "merge a number of columns together" do you mean concatenate the data in the cells across several columns into one cell? If so then use the concatenate operator "&":

    E1=A1 & B1 & C1

    Concatenates the data in A1:C1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •