Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |