View Single Post
  #1  
Old April 28th, 2010, 03:01 PM posted to microsoft.public.excel.worksheet.functions
skr
external usenet poster
 
Posts: 17
Default HOW DO I COLLECT TEXT DATA FROM A COLUMN

I have a worksheet of about 400 rows and 5 columns. Most of the data is
repeated with varying values. I need to calculate / separate data for each
item in the column. How do I do that? Iam using excel 2003. - for this
problem I tried to use the find command. But I am not able to save or copy
the data displayed. Any help is welcome.