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. Advertising

  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. Advertising

  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. Advertising

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. mm
    Replies:
    1
    Views:
    55
    Dave Peterson
    Oct 8, 2004
  2. mhillis

    merging cells without loosing info?

    mhillis, Nov 15, 2004, in forum: Excel Misc
    Replies:
    2
    Views:
    59
    JulieD
    Nov 15, 2004
  3. kalyan
    Replies:
    2
    Views:
    63
    David Biddulph
    Jun 18, 2008
  4. Technos
    Replies:
    0
    Views:
    61
    Technos
    Nov 13, 2007
  5. Buff1957
    Replies:
    1
    Views:
    44
    Doug Robbins - Word MVP
    Jul 6, 2006
Loading...

Share This Page