View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
helen helen is offline
external usenet poster
 
Posts: 105
Default Concatenate Formula not working

I have been using the concatenate function for a while now but recently it
just stopped working. these are numerical columns. i go to insert- Function-
concatenate, put in the cell #'s i want in the correct box and press enter.
all works according to plan.
however once i try to have the data extend down the column, it just shows me
the data from the first box on every box below it! What usually works is just
doing copy of the original cell and highlighting down. all the rest of the
data just appears.
it's not working and i have a deadline.
help me please!