Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging cells
I am trying to clean up an excel doc by merging data in many cells into one
and deleting the original cells. THis however cannot be done it seems as the references are then invalid? Thanks for any help...... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging cells
That would be true..........whatis it that you are really wanting asthe end
result?..........perhaps there's another way......... Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote: I am trying to clean up an excel doc by merging data in many cells into one and deleting the original cells. THis however cannot be done it seems as the references are then invalid? Thanks for any help...... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging cells
There is information regarding a projects requirement sacttered over many
cells and I want this info in one. Rather than copying and pasting from all of these seperate cells, is there another way? Thanks again "CLR" wrote: That would be true..........whatis it that you are really wanting asthe end result?..........perhaps there's another way......... Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote: I am trying to clean up an excel doc by merging data in many cells into one and deleting the original cells. THis however cannot be done it seems as the references are then invalid? Thanks for any help...... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging cells
Perhaps CONCATENATION would serve you.........
ie: if A1=Merry and B1=Christmas, then this formula in C1 would return Merry Christmas........... =A1&" "&B1 hth Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote in message ... There is information regarding a projects requirement sacttered over many cells and I want this info in one. Rather than copying and pasting from all of these seperate cells, is there another way? Thanks again "CLR" wrote: That would be true..........whatis it that you are really wanting asthe end result?..........perhaps there's another way......... Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote: I am trying to clean up an excel doc by merging data in many cells into one and deleting the original cells. THis however cannot be done it seems as the references are then invalid? Thanks for any help...... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging cells
Thanks for the advice,
one last thing, would that still not make the refs redundant? Thanks again "CLR" wrote: Perhaps CONCATENATION would serve you......... ie: if A1=Merry and B1=Christmas, then this formula in C1 would return Merry Christmas........... =A1&" "&B1 hth Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote in message ... There is information regarding a projects requirement sacttered over many cells and I want this info in one. Rather than copying and pasting from all of these seperate cells, is there another way? Thanks again "CLR" wrote: That would be true..........whatis it that you are really wanting asthe end result?..........perhaps there's another way......... Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote: I am trying to clean up an excel doc by merging data in many cells into one and deleting the original cells. THis however cannot be done it seems as the references are then invalid? Thanks for any help...... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging cells
All this does is CONCATENATE what you have in other cells together into a new
cell. The original cells should stay intact. Sorry I haven't been responding too quickly, but my Newsgroup access has been interrupted. Hopefully all is well now. So, if you are still having trouble with it, perhaps give us some more info as to what you have in what cell, and how it responds....then, someone will help. Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote: Thanks for the advice, one last thing, would that still not make the refs redundant? Thanks again "CLR" wrote: Perhaps CONCATENATION would serve you......... ie: if A1=Merry and B1=Christmas, then this formula in C1 would return Merry Christmas........... =A1&" "&B1 hth Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote in message ... There is information regarding a projects requirement sacttered over many cells and I want this info in one. Rather than copying and pasting from all of these seperate cells, is there another way? Thanks again "CLR" wrote: That would be true..........whatis it that you are really wanting asthe end result?..........perhaps there's another way......... Vaya con Dios, Chuck, CABGx3 "Al_baker" wrote: I am trying to clean up an excel doc by merging data in many cells into one and deleting the original cells. THis however cannot be done it seems as the references are then invalid? Thanks for any help...... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Merging cells with the same values | Excel Discussion (Misc queries) | |||
Merging Two Cells and Keeping the Values | Excel Discussion (Misc queries) | |||
WRAP a text line over several columns without merging cells | Excel Worksheet Functions | |||
Merging cells with text as one line | Excel Worksheet Functions |