Solved

How to Merge Three Cells in Excel 2003 without losing the data

Posted on 2012-03-23
5
447 Views
Last Modified: 2012-04-01
Dear Microsoft Office Experts

Note: OS is Windows 7

History:  I copied my SMS messages from Nokia 6300 to my PC using Nokia suite in .csv format because my Nokia phone is almost broken and I was lucky to access to copy messages somehow after too many attempts. Excel sheet got 3 columns & 157 rows . Column 1 got date, Column 2 got time , column 3 got my very lengthy messages. Due to this I can't copy directly to word document because it copied in very weird way only part of the message text is showing up.
So First I want to merge these 3 columns and able to copy in word doco easily to print off as I like to.
Example :
13-Jan-12  7:57:00 PM   SMS Text...........................................
14-Jan-12  2:00:00 PM   SMS Text ...........................................

Please guide.
0
Comment
Question by:MSGK161091
  • 3
  • 2
5 Comments
 
LVL 41

Assisted Solution

by:dlmille
dlmille earned 250 total points
Comment Utility
put this formula in column 4 (column D), say, starting row 2:

[D2]=A2 & " " & B2 & " " & C2

Copy that down.

Now, you can copy column D into your word document.

Cheers,

Dave
0
 
LVL 1

Author Comment

by:MSGK161091
Comment Utility
Hi Dlmille
It copied A2, B2 C2 to D2  But it messed up the format  14-jan-11 (cell A2) appearing like 40557 in Cell D2.
So time not copied exactly.
0
 
LVL 41

Accepted Solution

by:
dlmille earned 250 total points
Comment Utility
Ok - let's do this:

assuming A has date, B has time and C a text stream:

[D2]=Text(A2,"DD-MMM-YY") & " " & Text(B2,"H:MM:SS AM/PM") & " " & C2

And copy down

If you still have problems (if not exactly what you want) then upload a couple rows and I can perfect.

Dave
0
 
LVL 1

Author Comment

by:MSGK161091
Comment Utility
it worked this  time.. Gr8.... nicely copied to word doco.  I am done with what I want to do.
Thanks a lot lot..

But I want to keep this question open for few days to see how can I able to merge cells without losing the data because when I select 3 cells A1, B1, C 1 and right click to check merge option, it keep the data of cell A1 only after merging three cells into 1.

Cheers!
0
 
LVL 41

Expert Comment

by:dlmille
Comment Utility
It will work EVERY TIME, lol.

Feel free to wait a few days, though if we all did that, you'd still be waiting on your answer, lol (just joking ;)

You cannot use the merge function to merge multiple cells together and retain the data.  The concatenation formula is the appropriate approach to achieve that end.

See the image direct from MS Excel:
MS Help
However, if your cells were in multiple rows, rather than columns, it is possible in a few steps to do it but only in one instance - not the entire dataset, as chandoo describes:http://chandoo.org/wp/2010/12/07/merge-cells-without-loosing-data/

Sorry, there's no other "tricks" to achieve this other than writing a VBA macro which takes longer than just using the formula I gave you.

Cheers,

Dave
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now