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. |
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. |
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. |
All times are GMT +1. The time now is 12:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com