I am trying to add text using the concatenate function....for example=concatenate(a2,b2,c2) which works fine however if I try this =concatenate(a2:c2) comes back with a hashVALUE error....but......
What I am trying to achieve is to extract data from a report which gives me the subject the...