+ Reply to Thread
Results 1 to 3 of 3

How to get 3-4 cell data in 1 cell ?

  1. #1
    Registered User
    Join Date
    02-04-2010
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to get 3-4 cell data in 1 cell ?

    Hi frends, How are you ? i need your help pls

    It is really hard to give a subject name when you don't know how to explain (not even to your self).

    How to get 3-4 cell data in 1 cell ?
    for example

    A1 It is really hard to give a subject
    A2 name when you don't know how to explain
    A3 (not even to your self).

    i want A1, A2 and A3 data in one cell, either in A1 or any other cell
    that should be like
    A1 = It is really hard to give a subject name when you don't know how to explain (not even to your self).
    Thanx

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    Re: How to get 3-4 cell data in 1 cell ?

    Use & for combining cells.

    =A1&A2

    If you need space between you need to include aditional " "

    =A1&" "&A2

    Also, you can include some words, not only references (note space after this instead of aditional &" ")

    ="Try this "&A1
    Never use Merged Cells in Excel

  3. #3
    Registered User
    Join Date
    11-15-2007
    Posts
    57

    Re: How to get 3-4 cell data in 1 cell ?

    I would use concatenate for this but the result would not be able to be posted into any of cells A1, A2 or A3.

    On your example this would be:

    =concatenate(A1," ",A2," ",A3)

+ 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