+ Reply to Thread
Results 1 to 6 of 6

Multiple cell content

  1. 11-02-2015, 05:25 AM #1
    Shadmani
    Shadmani is offline
    Forum Contributor
    Join Date
    07-08-2009
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    142

    Multiple cell content

    Hi,

    If I have information on few cells...how can bring them all in one cell without using "&" in each cell as formula ?

    Thanks
    Reply With QuoteRegister To Reply
  2. 11-02-2015, 05:32 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Multiple cell content

    You can use the CONCATENATE function if you don't like to use &

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 11-02-2015, 05:45 AM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: Multiple cell content

    Well, if you were going to use =B2&C2&D2 but you don't like the ampersand (&), as Pete says, you can use CONCATENATE ... but that's basically the same thing:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    If you don't want a formula, you can use a User Defined Function, for example, ConcatAll (by TigerAvatar)

    Please Login or Register  to view this content.

    There are other variations around. Have a look at the example workbook attached.

    Regards, TMS
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 11-02-2015, 08:41 AM #4
    Doc.AElstein
    Doc.AElstein is offline
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Multiple cell content

    Notice to PeteUK

    @ TMS and Shadmani
    Sorry to hijack Thread, But Email Notifications are not working and Pete's PM In Box is full

    @ Pete

    Email Notifications appear not to be working again ( And your PM In Box is full )

    http://www.excelforum.com/suggestion...ml#post4230901

    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
    Reply With QuoteRegister To Reply
  5. 11-02-2015, 09:59 AM #5
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,705

    Re: Multiple cell content

    Quote Originally Posted by Doc.AElstein View Post
    [B]@ Pete

    Email Notifications appear not to be working again ( And your PM In Box is full )

    Alan
    Yes, I've just replied to your other thread. They seem to have stopped for me on Saturday. I didn't even get a notification that you tried to send me a PM and my inbox is full, which I usually get.


    Trevor,

    Perhaps the OP doesn't want to use a formula, so =ConcatAll(B2,C2,D2) also wouldn't be acceptable.

    Pete
    Reply With QuoteRegister To Reply
  6. 11-02-2015, 10:34 AM #6
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,380

    Re: Multiple cell content

    @Pete: dohhhh ... I wasn't thinking of the UDF as a formula My bad, I guess.

    If ampersand and other formulae, including a UDF are not acceptable, the only alternative that I can think of is to copy and paste from each cell.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining multiple cell content based on multiple criteria (IF, LOOKUP, INDEX??)
    By MacWatts in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-20-2014, 04:43 PM
  2. Add cell content into Formula command in another cell for multiple files search
    By Waleicow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-12-2014, 02:02 AM
  3. [SOLVED] multiple find and replace cell content based on another cell
    By betatony in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-27-2014, 03:07 PM
  4. [How to] Change cell content in multiple files
    By shortcutz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 05:49 AM
  5. How to combine content of multiple cells into one cell
    By friend11_6 in forum Excel General
    Replies: 3
    Last Post: 07-10-2009, 11:25 AM
  6. Split Cell content in multiple cells
    By pomolo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2008, 07:10 AM
  7. lookup cell content in multiple files
    By oldbuffer in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-13-2005, 02:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1