#1   Report Post  
lyneday
 
Posts: n/a
Default combining cells

how do i combine two cells in two rows into one cell without losing data

for example

A1 information here needs
A2 to be combined with information here
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

using a helper cell

=A1 & A2

Copy and Edit/Paste Special/Values back into a1

Via macro, one way:

http://www.mcgimpsey.com/excel/mergedata.html



In article ,
"lyneday" wrote:

how do i combine two cells in two rows into one cell without losing data

for example

A1 information here needs
A2 to be combined with information here

  #3   Report Post  
JMorrell
 
Posts: n/a
Default

Two ways that I know of.

if cell B5 has LastName and cell C5 has FirstName try this:
=CONCATENATE(B5,", ",C5)
this gives you "LastName, FirstName"

another way to do it is:
=B5 &", " & C5
this gives the same result.

hth,
JMorrell

"lyneday" wrote:

how do i combine two cells in two rows into one cell without losing data

for example

A1 information here needs
A2 to be combined with information here

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protected cells -automatically format to a different color Fred Evans Excel Discussion (Misc queries) 9 December 3rd 04 01:59 PM
Averaging only cells with data Randy Lefferts Excel Discussion (Misc queries) 9 November 30th 04 09:02 PM
Calculating without including Hidden Cells LiquidFire Excel Discussion (Misc queries) 3 November 29th 04 09:35 PM
how to update a shared workbook using the same cells at the same t Blair Excel Discussion (Misc queries) 0 November 26th 04 11:21 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 09:03 AM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"