Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I link text cells to another worksheet
I have a continous column of cells with text in them. I want to consolidate
all of the information in those cells into one cell in another worksheet. Any suggestions as to how I can accomplish this? FYI: copy and paste link does not work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I link text cells to another worksheet
hi sharon
Sorry if I misunderstood something, assuming yuo have the text between a2 and a20 =A2&A3&A4&A5&A6&A7...etc hth regards from Brazil Marcelo "SharonGaila" escreveu: I have a continous column of cells with text in them. I want to consolidate all of the information in those cells into one cell in another worksheet. Any suggestions as to how I can accomplish this? FYI: copy and paste link does not work. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I link text cells to another worksheet
How many cells are you talking about and how much text is in them?
What you want can be done but may not be practical due to some limits in Excel. Maybe some other method could be employed? If not, use this UDF to stick the text into one cell....comma delimited as written and ignores blank cells in the range. If don't want a comma just delete that from the code. Function ConCatRange(CellBlock As Range) As String Dim cell As Range Dim sbuf As String For Each cell In CellBlock If Len(cell.text) 0 Then sbuf = sbuf & cell.text & "," 'remove comma Next ConCatRange = Left(sbuf, Len(sbuf) - 1) End Function Usage is: ConCatRange(A1:A10) Gord Dibben MS Excel MVP On Wed, 28 Jun 2006 10:49:01 -0700, SharonGaila wrote: I have a continous column of cells with text in them. I want to consolidate all of the information in those cells into one cell in another worksheet. Any suggestions as to how I can accomplish this? FYI: copy and paste link does not work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked cells and text boxes | Excel Discussion (Misc queries) | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
excel contents cells on different worksheet like a comment | Excel Discussion (Misc queries) | |||
assemble link from different cells and return value | Excel Worksheet Functions | |||
How do I link one TEXT cell to others in a worksheet and workbook. | Excel Worksheet Functions |