how do I merge 2 cells in excel without loosing data

Discussion in 'Excel Misc' started by wimmat, May 19, 2005.

  1. wimmat

    wimmat Guest

    how to merge two colums?
    one contains text rows
    the other contains numeric data
    without loosing any of the data
    this means merging the data also

    thanks for your help
     
    wimmat, May 19, 2005
    #1
    1. Advertisements

  2. wimmat

    Max Guest

    Try Debra's nice coverage at her:
    http://www.contextures.com/xlCombine01.html

    She also provides some examples of how to format the numeric data part when
    it's combined with text under the "Formatting Examples" section - scroll
    down towards the end of the page
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "wimmat" <> wrote in message
    news:...
    > how to merge two colums?
    > one contains text rows
    > the other contains numeric data
    > without loosing any of the data
    > this means merging the data also
    >
    > thanks for your help
     
    Max, May 19, 2005
    #2
    1. Advertisements

  3. wimmat

    Jess Guest

    Put this formula in a third column:

    =CELL1&" "&CELL2

    Where CELL1 = the first cell you want to merge, eg A1 and CELL2 = the second
    cell, eg B1 - NB there is a space between the "s

    Hope that makes sense
    Jess

    "wimmat" wrote:

    > how to merge two colums?
    > one contains text rows
    > the other contains numeric data
    > without loosing any of the data
    > this means merging the data also
    >
    > thanks for your help
     
    Jess, May 19, 2005
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. PeterCheang
    Replies:
    2
    Views:
    103
    PeterCheang
    Jul 14, 2003
  2. mm
    Replies:
    1
    Views:
    90
    Dave Peterson
    Oct 8, 2004
  3. mhillis

    merging cells without loosing info?

    mhillis, Nov 15, 2004, in forum: Excel Misc
    Replies:
    2
    Views:
    124
    JulieD
    Nov 15, 2004
  4. Vic1978
    Replies:
    5
    Views:
    72
    David McRitchie
    Dec 12, 2005
  5. Susan
    Replies:
    2
    Views:
    88
    JE McGimpsey
    Feb 26, 2007
  6. kalyan
    Replies:
    2
    Views:
    103
    David Biddulph
    Jun 18, 2008
  7. Ken B
    Replies:
    3
    Views:
    71
    Gord Dibben
    Sep 9, 2008
  8. benk
    Replies:
    1
    Views:
    83
    Sheeloo
    Nov 6, 2008
Loading...