Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Averaging only cells with data | Excel Discussion (Misc queries) | |||
Calculating without including Hidden Cells | Excel Discussion (Misc queries) | |||
how to update a shared workbook using the same cells at the same t | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |