compress cells
i have a number of records in a list in a column. I need to compress the
records so that all the records bunch up. e.g. rec1 rec2 rec3 becomes... rec1 rec2 rec3 is there an automatic way to do this? i have rather a lot of records to do it for! rgds, Tom |
tommy wrote:
i have a number of records in a list in a column. I need to compress the records so that all the records bunch up. e.g. rec1 rec2 rec3 becomes... rec1 rec2 rec3 is there an automatic way to do this? i have rather a lot of records to do it for! rgds, Tom Do I assume there is a space between "rec" and the number? (It's a bit hard to see from your post!) If so, just do a Find and Replace. Find "space" and replace with "" (nothing) -- Registered Linux User no 240308 Just waiting for Broadband to complete the conversion!(3 weeks and counting!) gordonATgbpcomputingDOTcoDOTuk to email me remove the obvious! |
There may well be an easier way to do what you need, but all I can think of
is this: Create a blank column to the left of your list. For the sake of argument, assume that your list is in column "B" and the blank column is column "A". Also assume that your list starts in row 2. Put the following formula in A2 and copy it down. =IF(B2="","",ROW()) Now merely sort columns A and B (using A as the sort key) -- for only the rows containing your list of course. The get rid of column A. Art "tommy" wrote: i have a number of records in a list in a column. I need to compress the records so that all the records bunch up. e.g. rec1 rec2 rec3 becomes... rec1 rec2 rec3 is there an automatic way to do this? i have rather a lot of records to do it for! rgds, Tom |
Tommy
Select the column. Hit F5 then SpecialBlanks<OK EditDelete. Shift cells up or if nothing in other columns, Delete entire row. Gord Dibben Excel MVP On Thu, 3 Feb 2005 04:11:06 -0800, "tommy" wrote: i have a number of records in a list in a column. I need to compress the records so that all the records bunch up. e.g. rec1 rec2 rec3 becomes... rec1 rec2 rec3 is there an automatic way to do this? i have rather a lot of records to do it for! rgds, Tom |
All times are GMT +1. The time now is 11:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com