Microsoft Office Forums


Reply
Thread Tools Display Modes

how do I merge 2 cells in excel without loosing data

 
 
wimmat
Guest
Posts: n/a
 
      05-19-2005, 07:22 AM
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
 
Reply With Quote
 
 
 
 
Max
Guest
Posts: n/a
 
      05-19-2005, 09:19 AM
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" <(E-Mail Removed)> wrote in message
news:C48814C0-6C74-4874-AB9C-(E-Mail Removed)...
> 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



 
Reply With Quote
 
 
 
 
Jess
Guest
Posts: n/a
 
      05-19-2005, 09:50 AM
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MERGING CELLS WITHOUT LOOSING DATA IN THE SECOND CELL kalyan Excel Misc 2 06-18-2008 07:28 AM
Replace static data by dynamic data without loosing all the formul Technos Excel Worksheets 0 11-13-2007 10:23 PM
How do I mail merge an email without loosing the attachment? Buff1957 Word Mail Merge 1 07-06-2006 04:42 PM
merging cells without loosing info? mhillis Excel Misc 2 11-15-2004 03:01 PM
merging two cells without loosing data mm Excel Misc 1 10-08-2004 01:08 AM


All times are GMT. The time now is 03:48 AM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.


Welcome!
Welcome to the Microsoft Office Forums
 


Latest Threads
Word 2013 Insert Symbol (Not Responding)
tpthrshr (Today, 02:49 AM)

Can't save a large Word document
Josh (Today, 01:03 AM)

Remote help?
newman200 (04-13-2014, 12:54 PM)

Access command button help needed
MikeyL (04-06-2014, 07:01 PM)

Page number problem
satrah (04-06-2014, 10:48 AM)