Thread: compress cells
View Single Post
  #2   Report Post  
Gordon
 
Posts: n/a
Default

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!