+ Reply to Thread
Results 1 to 3 of 3

Automatic copy of several cells to paste into one cel

  1. #1
    Registered User
    Join Date
    05-12-2008
    Posts
    3

    Automatic copy of several cells to paste into one cel

    Does anyone know where I can get info on this or what it may be called?
    I have text rather than data in cels in spreadsheet. I want excel to pick up the text from several cels and put it into one cel (rather than me having to copy and past all the time.).

    ie. (each of these below is in a different cel)
    Brown
    2005
    Immunology
    volume 6
    no. 5
    pp. 32-999

    I want them to ALSO be in a cel that says :
    Brown 2005 Immunology volume 6 no. 5 pp.32-999.

    Any help or clues would be MUCH appreciated. Thanks. jinj

  2. #2
    Registered User
    Join Date
    05-12-2008
    Posts
    5

    Concatenate

    Hi,
    Paste formula =CONCATENATE (text1,text2,...)
    Joins several text cells into one text string.

  3. #3
    Registered User
    Join Date
    05-12-2008
    Posts
    3

    Automatic copy of several cells to paste into one cel

    Thank you so much its exactly what i wanted. Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1