View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vanjoli
 
Posts: n/a
Default Using list of data in another worksheet

I am trying to take an imported text list of first and last names from one
worksheet and using =A2&", "&A1 on a second worksheet, I want to list all of
the names with a blank line between each of the names. There are too many
names to enter this formula each time. Whenever I try a series, it skips a
name. Any ideas how to easily do this?